Re: [Fwd: locking a row in a database]
From: DanHW <danhw_at_aol.com>
Date: 2 Mar 1999 22:35:45 GMT
Message-ID: <19990302173545.09850.00002113_at_ng-ce1.aol.com>
Date: 2 Mar 1999 22:35:45 GMT
Message-ID: <19990302173545.09850.00002113_at_ng-ce1.aol.com>
>I was wondering if there is anyway to lock a row in a table so that no
>one can modify it and then check if there is a lock on that row even if
>i own that lock on the row. I guess it would also be useful to know how
>to remove the lock also.
>
One way is to open a cursor on the row with a FOR UPDATE clause.
To release the lock, do a COMMIT. You could also probably close the cursor as well.
Dan Hekimian-Williams Received on Tue Mar 02 1999 - 23:35:45 CET