Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a cursor-error message
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01515250
Message ID:
01515251
Vues:
88
This message has been marked as the solution to the initial question of the thread.
Add READWRITE clause to make cursor updateable and check http://www.berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors
SELECT * ;
	FROM GRPEXTCV ;
	INTO CURSOR tmpGRPEXTCV READWRITE
>I index cursors all the time so this surprises me today. The error message states: "File must be opened exclusively".
>
>I even set exclusive on, recreated the cursor and then tried the indexing again, but received the same error message.
>
>Here's the simple SQL statement and INDEXing command:
>
>
>SELECT * ;
>	FROM GRPEXTCV ;
>	INTO CURSOR tmpGRPEXTCV
>
>SELECT tmpGRPEXTCV
>INDEX ON GrpID+GrpNum+PlanKey TAG FULL_KEY
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform