I have a multi-user problem with stored procedures.

How do I go about implementing a record lock in a stored procedure so
as to prevent another PC running that procedure from working on the
same record ?

ANd then how do I detect this condition in the stored procedure.

Regards


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz