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?

TIA