General information
Category:
Coding, syntax & commands
>
(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.
Previous
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