Information générale
Catégorie:
Codage, syntaxe et commandes
>
(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
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