Re: Record has been change by another user please re-query ???
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/12/23
Message-ID: <4bhhdb$dsh_at_ixnews4.ix.netcom.com>#1/1
Date: 1995/12/23
Message-ID: <4bhhdb$dsh_at_ixnews4.ix.netcom.com>#1/1
staccuc_at_riq.qc.ca (Sylvain Taccucci) wrote:
>When FORMS detect that a queried record has been change by another
>user, it tells you so as soon as you tried to modify it, that is when
>FORMS tried to lock it. Which mecanism FORMS use in order to know
>that the record has been changed ???
It re-queries the record immediately prior to updating and compares it to the originally queries values. Power builder does the same thing. You should be able to prevent this by doing the initial select as a "FOR UPDATE" select. Nobody else can change it then.
-- Chuck Hamilton chuckh_at_ix.netcom.com If at first you don't succeed, sky-diving isn't for you.Received on Sat Dec 23 1995 - 00:00:00 CET