Re: Oracle Forms: How do I Update a Detail Updateable Query

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 12 Mar 2003 08:31:06 -0800
Message-ID: <3E6F60CA.2E4C276D_at_exesolutions.com>


DCCoolBreeze wrote:

> I have two views similar to two tables. One is the main view and the
> other is the detail view. I have placed them onto a canvas and they
> do display to correct records relative to their keys. I can update
> and delete records on the main view but I cannot update or delete
> records on the detail view. Basically it returns the error FRM-40200
> - field is protected against update. The update allowed property is
> set to yes.
>
> Any help?

You will likely need an INSTEAD OF trigger due to the possibility of updating the primary key in the underlying table.

If your views are similar to the tables why use the views?

Daniel Morgan Received on Wed Mar 12 2003 - 17:31:06 CET

Original text of this message