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
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