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
Sure. It's article ID: Q138094 -- "How to Create Updatable Views by Using SQL Passthrough"
Here's the first paragraph:
Remote views provide the most common and easiest way to gain access to and update remote data. You can also use SQL passthrough technology to send SQL statements directly to a server. By default, a SQL passthrough query always returns a non-updatable snapshot of remote data, which is stored in an active view cursor. You can make the cursor updatable by setting properties with the CURSORSETPROP() function. An updatable remote view, in contrast, usually doesn't require that you set properties before you can update remote data.
etc...
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