Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select cursors
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00747843
Message ID:
00747846
Views:
19
In VFP7 add READWRITE clause to SELECT to make cursor read/write. In VFP6 add NOFILTER to make sure that cursor is created as a temp dbf and than reopen it with AGAIN clause.
SELECT ... ;
INTO CURSOR temp NOFILTER
USE ( DBF("temp")) IN 0 AGAIN ALIAS MyReportCursor
USE IN temp 
SELECT MyReportCursor
>I love using the Select ... Into cursor command to create recordsets for reports. Is there any way to have these cursors be read/write like cursors created with the create cursor command? I don't want to update the tables behind the query, just manipulate the cursor a little before calling the report.
>
>Thanks!
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform