Viv,
I donot allow other person to change a record while it is being used by someone. I lock that record programatically!
So I think, Force update will solve this problem.
Thanks again for your help!!
Regds
Shaishav
>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
Regards
Shaishav