Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>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...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement