Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing for a Group/Total report
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00147217
Message ID:
00147261
Views:
45
>>>>>Hi all,
>>>>>
>>>>>I have an interesting problem. I have an SQL-Select statement that copies into a table. Everytime I test the program, I get an error that says "Index tag not found".
>>>>>
>>>>>I included these lines after my SQL-SELECT:-
>>>>>
>>>>>SELECT myTable
>>>>>INDEX ON myField TO myIndex
>>>>>SET ORDER TO myField
>>>>>
>>>>>Any ideas??
>>>>>
>>>>>TIA
>>>>
>>>>Try:
>>>>
>>>>INDEX ON myField TAG myIndex
>>>>SET ORDER TO TAG myIndex
>>>
>>>I tried it, Fred...didn't work. Still get the same error when i want to run the report.
>>
>>Is your report using a private datasession? Change it so it doesn't.
>
>I didn;t use a private datasession when I created it

Is your index even getting created? Maybe you need to see if it's available when the report runs. Put a field in the report temporarily to show you the current index tag. Use TAG() as the field value, say in the page header, and see what it says.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform