Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough
Message
 
 
To
07/11/2001 08:42:31
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00578326
Message ID:
00578453
Views:
20
>
(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
Map
View

Click here to load this message in the networking platform