REPOST: 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
>
>

• WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: cschang <cschang_at_maxinter.net> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel <3C2FEC65.2040901_at_maxinter.net> Control: cancel <3C2FEC65.2040901_at_maxinter.net> Date: Wed, 2 Jan 2002 03:00:26 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3C2FEC65.2040901_at_maxinter.net> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009943504 19888 166.102.15.34 (2 Jan 2002 03:51:44 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 03:51:44 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent?

autocancel Received on Sun Dec 30 2001 - 22:41:09 CST