>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--