Re: Could not reserve record (2 tries)...

[Quoted] "Pat" <Pat_at_microsoft.com> wrote in message news:dkqpkk$ci5$1_at_news.hgc.com.hk...
> Hi All,
>
> While a row is being locked by another process, Oracle forms will pop
> up "Could not reserve record (2 tries)" message. I tried to customize
> this message by:
>
> In ON-LOCK trigger,
> select the same row for update nowait;
> if record being locked (oracle error code 54), display the customised
> message.
>
> However, oracle forms displayed the customized message twice rather than
> once!!
>
> Does anyone know the reason why? and how to bypass it?
>
> Thanks
>
>

looks like it's doing what it original did, but just with your code (2 tries)

try the ON-MESSAGE or ON-ERROR trigger (i'm thinking ON-MESSAGE is the one)

++ mcs Received on Tue Nov 08 2005 - 19:49:36 CET