Cursors by default are read only. In VFP 9 you add the "readwrite" option to the end of the SQL statement and in earlier versions you add the "nofilter" option to remove the caching to ensure you get all the records in the cursor not just cache records and then the secret is to open the cursor again as a dbf table using:
select .... into cursor <cursorname> nofilter use dbf(<cursorname>) again in 0 alias <newalias> you can then write to the cursor as required Dave C -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of John J. Mihaljevic Sent: 29 March 2013 21:42 To: [email protected] Subject: Error running second instance of EXE (more) Correction: Two cursors aren't being created when the form loads. One is a cursor and one is a dbf. Both done using the SQL SELECT command. Are DBFs created this way made exclusive by default? Just trying to see if my problem is the DBF, the cursor or both. Thanks, all. John [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
