this one is new to me! what is this "for update" clause? and how do u use it
in a select clause? is it databse specific.
TIA
Anamitra
-----Original Message-----
From: Victor Langelo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 5:14 PM
To: [EMAIL PROTECTED]
Subject: Re: Serialized Access
"Bhattacharyya, Ana" wrote:
> also I cannot
> do this check in two queries (first check the timestamp and then update)
as
> they cannot be made atomic.
> correct me if I am wrong.
>
You use the for update clause when selecting the timestamp value. This will
lock
the record.
--Victor
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
STATEMENT OF CONFIDENTIALITY. The information contained in this electronic
message and any attachments to this message are intended for the exclusive
use of the addressee(s) and may contain confidential or privileged
information. If you are not the intended recipient, please notify
USPowerSolutions Corporation immediately at (617) 547-3800, or at
[EMAIL PROTECTED], and destroy all copies of this message and any
attachments.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
