Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate(), Pls Help
Message
From
17/07/2004 07:38:13
 
 
To
17/07/2004 01:28:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00925076
Message ID:
00925462
Views:
15
Hi,

>>
Ok, now I am running the Begin/End Transaction, and capturing error if any. but how do I handle if there is any conflict.

I am sure there must be better solution than Rollback.
>>

RolBack is the first part of the solution. What you do after that will depend on the reason a TableUpdate failed and your application requirements. As Hilmar mentioned you can use AERROR() to find the cause of the fail. If the TableUpdate() failed because of data conflict you can compare the data you are trying to write to the current underlying data using the CURVAL() function. If you decide that it's OK to overwrite the other changes you can redo the TableUpdate()'s using the 'Force' parameter.

HTH,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform