Re: Forms 6i and Oracle 8i

Do you have ON-LOCK trigger to lock rows you are updating in ON-UPDATE trigger? If not, I'd recommend to read 'Advanced Techniques with Oracle Forms' manual first.

In article <oe566.19515$0d.1202011_at_nnrp4.clara.net>,   "Andy Collins" <andy.collins_at_clara.co.uk> wrote:
> Hi,
>
> I've created a view on the database and based a block upon it. In
 order to
> update the data I use an On-Update trigger to maintain the data on the
 base
> tables. Running against DB 7.3.4 it works correctly but we are in the
> process of upgrading to 8.1.6 and testing against this platform
 message
> 'FRM-40654: Record has been updated by another user. Re-query to see
 change'
> appears when any data is updated. Note, this is when data is changed
 on the
> form and not when commited to the database.
>
> Removing the On-Update trigger gives message 'FRM-40602: Cannot insert
 into
> or update data in a view' which is as expected.
>
> My resolution has been to create an 'INSTEAD OF' trigger on the view
 which
> only contains 'NULL;' within the body thus allowing the original code
 to
> work.
>
> Have I missed a property on the block or is this how Forms works
 against
> Oracle 8i?
>
> Forms version 6.0.8.10.3 - 6i with patch set 1.
>
> Thanks for your help.
>
> Andy.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 08 2001 - 18:54:14 CET