>>>>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.
>>>>
>>>>Here is the segment of the code dealing with creating new order:
>>>>
>>>>

>>>>INSERT INTO V_ORDERS ( STATUS, DATE_OPEN,  OPEN_TIME, USER_NAME, USER_ID, INSP_PASS, SITE_NO ) VALUES ;
>>>>				('O', DATE(), time(), oPassword.UserName(), oPassword.User_Password_Id(), NULL, this.site_no )
>>>>
>>>>	IF !TABLEUPDATE(0,.T., "V_ORDERS" )
>>>>		AERROR(aErrorInfo)
>>>>		this.error_message_text = aErrorInfo[1,2]
>>>>		this.error_number = aErrorInfo[1,1]
>>>>		this.error_message_title = "Failed TABLEUPDATE() of V_ORDERS"	
>>>>		RETURN .F.
>>>>	ENDIF
>>>>

>>>>
>>>>The error (which is logged) does not seem to fire. But is it possible that the TABLEUPDATE() takes "time" (a second or two or more) to actually update the SQL Server. And therefore, the second user's TABLEUPDATE() overwrites the first one? If this is the case, how do I "force" the tableupdate to be faster? Or any other suggestions to deal with this situation?
>>>>
>>>
>>>Is there an Insert trigger on the SQL Server table? If so, what does it do?
>>>
>>>Tamar
>>
>>No, there is no insert trigger on this table. Why would it be necessary?
>
>Where do you have the logging of the error? Are you sure it's logged? Can you try simulating the situation locally if, say, you have 2 computers with that application and ask your wife or daughters to press Save by your command?

I checked on the customer server and there is no error log file (which would have been created had tableupdate() failed). I don't have another computer to simulate a network. And doing it on my computer does not create duplicates. In fact, no other customer reported this type of situation. On the last point, I work from an office outside home so there is no wife here. My daughters are adults and do not live with us. And if I ask them to do something like this, they will give me a strange look :)
Thank you.