Re: Question about locking a record.

Thanks Steve. I know I can use " FOR UPDATE" at end of the "SELECT ..". but how can I lock it for a certain of period , not at the moment of the "SELECT .." and consequently "UPDATE.. " statement. Because my next step of the possible process will make the record not available for any other user, so I do not want the reocrd to be updated after my updating unless I do not process further. I hope that above statement does confuse you.

C Chang

Steve Bell wrote:

>Hi,
>
>I hope I understand your question...if you want to select a record and lock
>it you can use the SELECT...FOR UPDATE
>syntax.
>
>Hth,
>
>Steve
>
>
Received on Sun Dec 30 2001 - 22:41:09 CST