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