Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a cursor-error message
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01515250
Message ID:
01515251
Views:
87
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform