Hi,
There is no need to handle locking with SQL server. Database system do it instead. For example,in Oracle, when updating a record without Commit. That record will be locked and no one could modify it (read is ok). Once it's commit/rollback the record will be released.
So, in a C/S apps, you can use Begin/End transaction, Rollback, tableupdate, tablerevert to control the flow of update, delete.

:) Wilfred

>Dear all,
>The VFP command rlock() or flock() do not function on locking
>a record resides in SQL Server. Do you have any idea on that ?
>Any suggestion will be appreciated.