Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index (CDX) a SQL - Cursor, File Read-Only
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00568979
Message ID:
00568981
Vues:
24
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform