Re: Forms4.5 question -- 2 users accessing the same row in table

From: Shawn Odekirk <shawno_at_erudite.com>
Date: 1997/03/31
Message-ID: <01bc3e0c$58d958e0$050264c8_at_Shawno.erudite.com>#1/1


> In testing, we have found that if one user is updating the document, the
> others who try to show it get a Forms4.5 "error" saying something like the
> data cannot be obtained, keep trying? You can click yes or no and then it
> appears to continue trying to query the data.
>
> How can we avoid that situation? Do we issue some type of lock? Also, has

Take a look at the Locking Mode property of your block. The default Locking Mode is Immediate. The online help recommends leaving the Locking Mode set to Immediate for Oracle databases and only using Delayed Locking Mode with non-Oracle databases.
I have never used Delayed Locking Mode, but it looks like it may do what you need.

Shawn Received on Mon Mar 31 1997 - 00:00:00 CEST

Original text of this message