Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you add records to a cursor?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00252128
Message ID:
00252143
Views:
10
>>
>>A cursor created by SELECT - SQL is read-only. However, you can issue a USE...AGAIN on the cursor; this renders it read-write, where you can perform nearly all table-related operations.
>>
>>There's an article in the Knowledgebase FAQs on this.
>
>Thanks to Evan Delay for posting that FAQ!

Jeff,

Be carefull! VFP may simply use the dbf again and set a fitler to provide your cursor. If it does this and you USE DBF("CursorName") AGAIN you will be appending into the actual source table and not some temp table that will be destroyed. Be sure you use the NOFILTER option on the SELECT command to force VFP to create a disk file for the cursor.
Previous
Reply
Map
View

Click here to load this message in the networking platform