Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Transaction Logic
Message
From
26/09/2001 11:08:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Problem with Transaction Logic
Miscellaneous
Thread ID:
00560992
Message ID:
00560992
Views:
51
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
Map
View

Click here to load this message in the networking platform