Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Passthrough
Message
 
À
07/11/2001 08:42:31
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00578326
Message ID:
00578453
Vues:
18
>
(I think) If you open a table with pass throught, you must be update table with pass throught.
>

Not true. You can open a table via SPT and use a series of CursorSetProp calls make the cursor an updateable one via TableUpdate. Combine this with either row or table buffering, and you can control when updates are sent back to the server. It is essentially what a RV is, except that in a RV, a lot of what occurs, happens in the background.

Alternatively, you can render your updates manually with SPT. You can do this with a client-rendered SQL Update. Or, you can invoke a stored procedure and pass the required parameters to the proc.

In any scenario, if multiple rows are being edited, most likely, you will want to wrap the updates in the context of a transaction.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform