Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'set relation to' on sql cursor
Message
From
18/02/2003 10:13:52
 
 
To
18/02/2003 10:01:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00753966
Message ID:
00754465
Views:
23
SWEEEEEEET!!! That was it!!! I love UT. Thanks, Jim

>Just a SWAG, but have you tried with the READWRITE clause of Select-SQL?
>
>good luck
>
>
> >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
Previous
Reply
Map
View

Click here to load this message in the networking platform