Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index (CDX) a SQL - Cursor, File Read-Only
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00568979
Message ID:
00568981
Views:
23
This message has been marked as the solution to the initial question of the thread.
>Dear all
>
>
>Hi, I have just created a SQL Cursor and am trying to index it using CDXs (they remove themselves with the cursor).
>
>
>The first INDEX ON ... TAG ... works just fine but as soon as I want to create a second INDEX ON ... TAG ... for the same cursor I get File Read-Only error.

>Any way this is possible with self removing CDX/IDX or do I have to revert making indexes using temporary name SYS(3)

You can use structural index but you have to open your cursor read/write
USE ( dbf("mycursor")) in 0 AGAIN alias temp1
USE IN mycursor
USE ( dbf("temp1")) in 0 AGAIN alias mycursor
USE IN temp1
SELECT mycursor
INDEX ON ...
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform