Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Transaction and Deleted record
I need a little advise on the following situation :
Code Example - select( table1 )
abc = fieldabc
if seek(upper( abc ),'table2','table2order')
DELETE in table2
repl someField with someValue in table1
tableupdate(0,.f.,'table1')
endif
I am trying to make sure that record gets deleted in table2 and if so that table1.someField gets changed, but if delete can fail or if table1 update fails put back like it was to start with.
Question 1.
Table2 is pess row buff, do I need to issue tableupdate or unlock after delete ? Could the delete fail ?
Question 2.
If I use BEGIN TRANS, END TRANS, ROLLBACK will the deleted record be put back if I issue ROLLBACK if any part of trans fails ??
*****
Some of the documentation I have read is vague on these issues, any help is appreciated.
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