Hi

I'd like to be able to perform record locking, row update, within SQL2000. Basically, I'm trying to do the following:

1. Select the correct record
2. Attempt to lock record
3. If able to lock, update a field within that record, release lock
4. If not able to lock, attempt to lock for a specified amount of time.

Here are some questions:

1. If I attempt to lock the record with the select, what happens if the record is already locked or I'm unable to complete the lock? i.e. I'd want to be able to return a code to the calling program why the SQL procedure couldn't lock the record.

Basically, it's as simple as that but it I've found it hard work reading the on-line SQL help files. The record locking MUST be completed by SQL server as the procedure will be called from VFP, VB and various other technologies.

Regards