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