>How do you make a SQL Cursor writeable ?
>
>Select * from my_file into cursor my_cursor
>
>and then what?
>
>I seem to have seen a solution to this somewhere, but it just slipped my mind.
>
>Thanx
>
>Peter
Hi, Peter
As others have told you the solution is:
SELECT * FROM MyTable INTO CURSOR Query
USE DBF("Query") IN 0 AGAIN ALIAS Writable
I would suggest that you use the NOFILTER clause of SELECT-SQL to ensure that VFP is giving you a cursor, or you could inadvertently change your source table. The resultant cursor (Writable) is also bufferable, e.g. CURSORSETPROP("Buffering", 5, "Writable") will set optimistic table buffering.
HTH
Ned
Ned
Reality is.