General information
Category:
Coding, syntax & commands
>>>How do you make a SQL Cursor writeable ?
>> As others have told you the solution is:
>> SELECT * FROM MyTable INTO CURSOR Query
>> USE DBF("Query") IN 0 AGAIN ALIAS Writable
>>
>
>Also of note: Assuming that you want changes propagated through to a base table in a Client/Server application...there is a KB article that describes how to convert a result set (one returned via an SQL Pass-through query) into a read-write cursor such that changes will be propagated back to the base table on the server. It's basically done by using a bunch of cursorsetprop calls.
Hi Mark,
Would you know the title of this article?
Thanks,
Paul de Niverville
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only