(unknown charset) Re: Oracle Forms: How do I Update a Detail Updateable Query

If your DDL view columns are based on a single table than it is updateable in forms.
If your DDL view columns are based on more than one table, then it isn't updateable.
The fact that the form does not allow you to even update the field suggests you need to apply a patchset to your forms developer suite. There was bug in forms 6i that prevented the user from updating any view fields.

Regards
 

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

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar