>>Hi,
>>
>>I have a situation where one customer is experiencing the following: two users (on different PCs) create a new order and if they do it pretty much at the same time, the second one overwrites the first. The DB is SQL Server. The method of updating the DB is CursorAdapter.
>
>In the CA, if there's any code in the AfterInsert(), that code may do other things and possibly make other calls to SQL, which would reset your error data. You need to check lResult, the parameter of all after*, events and if .f., do aError() right there, before the error info is lost.
I am pretty sure that I don't have any code in my CA AfterInsert(). But I will double check. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
