Re: Locking Problem

From: <shaji_vps_at_hotmail.com>
Date: Thu, 25 Feb 1999 23:09:36 GMT
Message-ID: <7b4l78$pj7$1@nnrp1.dejanews.com>

Hi,

It is possible to lock a set of records. You have to only select those records first with the "FOR UPDATE" clause in ur select statement. This will issue a row level exclusive lock for all the rows selected by the query. After this u can update it, or do whatever u want. A commit/rollback will release the lock afterwards.

Shaji.
shaji_vps_at_hotmail.com

In article <7atn4n$snk$1_at_newnews.global.net.uk>, "John Francis Lundy" <jflundy_at_aol.com> wrote:
> Is it possible to lock a set of records?
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 17:09:36 CST