Record Locking

[Smallkeung]

I'm using Visual Basic 6 and SQL server 7.0 to develop a Multi-User application under the client/server environment.
I'll use the stored procedure to handle the transaction, but I don't know how to handle record locking for those transaction.
Can anyone suggest some solutions for me ?
I should handle the record locking on Visual Baisc or Stored procedure, and how to do this ?
Thanks

[Clunietp]

The stored procedure will automatically handle the record locking, you don't have to code for it.

You may want to use BEGIN TRANSACTION and COMMIT TRANSACTION in your stored procedure if you are doing updates/deletes on multiple tables


Tom