General information
Category:
Coding, syntax & commands
Hi,
>that is, what I expected. But somehow I am confused about the Begin Transaction - End Transaction - Rollback squence. The VFP help say to End Transaction.
>"Ends the current transaction and saves any changes made to tables, table memo files, or index files included in a transaction."
>... saves to what?
>
>Details: I have an SQL Server as back-end. Lets assume, I have 5 cursors with some changed data and I want to save the data to the SQL server with 5 TableUpdates(). When will these changes be "commited" finally, i.e. will be placed into the resp. tables within the SQL server? With each TableUpdate() or only after all reported "Could be done" (returned 5 times .T.), i.e. after the End Transaction?
>Unfortunately I did not find anything, which helps me to decide, what to do...
>
>Any help appreciated.
ROLLBACK should leave everything in the state if was in at the point the BEGIN TRANSACTION was issued, i.e. any TABLEUPDATES() issued in the interim would be undone and any buffered changes would still exist. But, as Srdjan pointed out, with remote views you also need to manage the transaction on the server.
HTH,
Viv
Previous
Next
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