>multi-environment. If user #1 selects row from
>SQL Server, he gets 1st status of this row. Then
>user #2 selects row from SQL Server too. He gets
>the same status as the former. User #1 updates the
>data. Then user #2 wants to update too but the
>data is already changed. He should receive warning
>message that is about the changed data. In SQL
>Server, It has automatically locked so I can't

I used optimistic row buffering for the views to the SQL DB. When I wanted to write the changes, I used something like :
IF !(=TableUpdate(.T.))
=MessageBox("Another user...",0,"Conflict")
=TableRevert()
ENDIF

HTH,
Scot.