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

DCCoolBreeze wrote:

> 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

If your INSTEAD OF triggers didn't work ... my inclination would be to believe that the problem is with your code rather than the trigger's functionality.

Why not restate the original problem, post the trigger and let us take a look.

Daniel Morgan Received on Sun Mar 16 2003 - 00:52:59 CET