Help with REPORT INDEX

[John Cosmas]

I created a work table using the SELECT .. INTO TABLE wrk_TABLE in my code.
In design mode, I created a report which uses the work table. However, the
work table is replaced by the SELECT INTO TABLE, and when I run the report,
it complains about INDEX TAG not found. Do I have to now include a INDEX
ON... statement to recover the situation, and how would I go about making
sure its' right. Any pointers would be most helpful.

[borisb]

Post by John Cosmas
I created a work table using the SELECT .. INTO TABLE wrk_TABLE in my code.
In design mode, I created a report which uses the work table. However, the
work table is replaced by the SELECT INTO TABLE, and when I run the report,
it complains about INDEX TAG not found. Do I have to now include a INDEX
ON... statement to recover the situation, and how would I go about making
sure its' right. Any pointers would be most helpful.

Remove DataEnvironment from Report. Also If you are printing when some
GRID has the focus this also can cause problems. Just SetFocus() to some
other control before printing.

[John Cosmas]

Did you mean on an object other than the report.

Post by borisb

Post by John Cosmas
I created a work table using the SELECT .. INTO TABLE wrk_TABLE in my
code. In design mode, I created a report which uses the work table.
However, the work table is replaced by the SELECT INTO TABLE, and when I
run the report, it complains about INDEX TAG not found. Do I have to now
include a INDEX ON... statement to recover the situation, and how would I
go about making sure its' right. Any pointers would be most helpful.

Remove DataEnvironment from Report. Also If you are printing when some
GRID has the focus this also can cause problems. Just SetFocus() to some
other control before printing.

[John Cosmas]

Did you mean on an object other than the report.

Post by borisb

Post by John Cosmas
I created a work table using the SELECT .. INTO TABLE wrk_TABLE in my
code. In design mode, I created a report which uses the work table.
However, the work table is replaced by the SELECT INTO TABLE, and when I
run the report, it complains about INDEX TAG not found. Do I have to now
include a INDEX ON... statement to recover the situation, and how would I
go about making sure its' right. Any pointers would be most helpful.

Remove DataEnvironment from Report. Also If you are printing when some
GRID has the focus this also can cause problems. Just SetFocus() to some
other control before printing.

[Olaf Doschke]

Post by John Cosmas
I created a work table using the SELECT .. INTO TABLE wrk_TABLE in my code.

That doesn't fill the table, but reacreates it, and by default,
it has no indices after that, true.

You may do
SELECT INTO CURSOR curTemp NOFILTER
set safety off
zap in wrk_Table
set safety on
select wrk_Table
append from dbf("curTemp")

Then you don't loose the indices.

You may also just recreate the indexes needed with
INDEX ON. But there is no way to tell what these
indexes were just by the Tag name you got reported
by the error message "INDEX TAG .. not found".
You need a copy of wrk_table with the approrpiate
indexes and find out there expressions with KEY()
or in the table designer.

Bye, Olaf.