|
Home > Archive > FoxPro database connector > June 2005 > Help with REPORT INDEX
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help with REPORT INDEX
|
|
| John Cosmas 2005-06-15, 3:25 am |
| 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 2005-06-15, 3:25 am |
| John Cosmas wrote:
>
> 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 2005-06-15, 11:25 am |
| Did you mean on an object other than the report.
"borisb" <borisb@mail.bg> wrote in message
news:OUBx2PYcFHA.2960@TK2MSFTNGP09.phx.gbl...
> John Cosmas wrote:
> 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 2005-06-15, 11:25 am |
| Did you mean on an object other than the report.
"borisb" <borisb@mail.bg> wrote in message
news:OUBx2PYcFHA.2960@TK2MSFTNGP09.phx.gbl...
> John Cosmas wrote:
> 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 2005-06-24, 3:24 am |
| > 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.
|
|
|
|
|