>I'm sorry for my unclear question. Assume that I
>use VFP as front end to contact with SQL Server in
>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
>lock the record and check the status before I
>update. What do others behave in this category? I
>am very new in client-server and using SQL Server.
>I have some solutions in my head but it's better
>to ask the expert before. May be next time, I will
>write about flow of update.
>
>Ver

Maybe turn off locking on the Server level?

Tom