Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Writeable Cursors?
Message
 
 
À
17/12/1997 00:44:05
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, Colombie Britannique, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00066144
Message ID:
00066779
Vues:
32
>>>>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
Fil
Voir

Click here to load this message in the networking platform