Samuel, see: BEGIN TRANSACTION, END TRANSACTION and ROLLBACK / COMMIT

>Hi all,
>Do you know how to issue a lock on a record of a table in SQL Server?
>It is required and useful for locking a record when in edit mode.
>Therefore any other user can not edit the same record at the same time.
>Can you show an example in VFP6 and SQL Server 7.0
>Thanks