General information
Category:
Coding, syntax & commands
Title:
Problem with Transaction Logic
Hi all
In a transaction how to allow the user to save information after there is a update conflict!
In the savedata method of my form
Begin transaction
select a && Bankaccount table
lSelectA=tableupdate(.t.)
sele b && Check table
lSelectB=tableupdate(.t.)
if lSelectA and lSelectB
wait wind 'record saved'
end transaction
else
if messagebox('Table is in use by another user',5+32+0,'Error')=4 &&Retry
rollback
thisform.savedata && is this Correct logic
else
rollback
endif
endif
thanks
ak
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