Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'set relation to' on sql cursor
Message
 
 
To
18/02/2003 09:39:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00753966
Message ID:
00754455
Views:
18
If you need to create more than one index, use ReadWrite clause.
SELECT ... INTO CURSOR mycursor READWRITE
INDEX ON myfield1 TAG myfield1
INDEX ON myfield2 TAG myfield2
...
>Okay... This works,... ONCE!!. I am wanting the Headers of a grid to re-index the data in the grid. The data is from a SQL cursor. With you suggestion, I can click a certain header to sort by QTY, and it work. But then if I click another column to sort by PRICE, it says "\xxx\yyy.tmp" is read only. It must be talking about the temporary index file it built from the first header click. I tried SET SAFETY OFF, but that did not help. It's seems you would need to release the index file, before trying to create another one, so I tried SET ORDER TO, but that did not help either. I am sooo close.
>
>
>
>>
>>Create structural index. It has the same name as cursor's temp. table, so you don't have to worry about it's name.
SELECT ... INTO CURSOR mycursor NOFILTER
>>INDEX ON myfield TAG myfield
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform