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

[Quoted] [Quoted] Unfortunately, I have to maintain the table structure. There are 4 tables; 2 sets of two identical tables with different names. Each two tables are combined using a "union all" clause.

I have instead of triggers defined but that did not work.

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<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 Sat Mar 15 2003 - 23:22:28 CET