Re: problem with updatable view an forms

Juergen Koehler wrote:

> Hi, Daniel,
>
> I already tried to work with an instead of trigger . But I get the same
> error message in the forms module ("it is not possible to update the
> view").
>
> Juergen Koehler
>
> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3E395295.C0164040_at_exesolutions.com...
> > Juergen Koehler wrote:
> >
> > > Hi, everybody,
> > >
> > > can anyone help me with the following problem?
> > >
> > > I created an updatable view of 5 tables a,b,c,d,e. Therefor I had to
> join a
> > > with b, b with c and d, c with d and e. The system view
> > > "USER_UPDATABLE_COLUMNS" says that nearly every column is updatable (but
> not
> > > insertable or deletable).
> > > If I do an update on this view via sqlplus it works. When I use a forms
> > > module with a block on this view the following message appears: "it is
> not
> > > possible to update the view". I set the block property "update changed
> > > columns only" to yes.
> > > Does anybody knows what the problem is?
> > >
> > > Greetings
> > >
> > > Jürgen Köhler
> >
> > Yes. Create an INSTEAD OF trigger on the view.
> >
> > Daniel Morgan
> >

If you wish ... send me the DDL for the tables and the view. I'll take a look.

No promises ... but I'll look at it. Heck. Maybe give it to my students as homework. <g>

Daniel Morgan Received on Fri Jan 31 2003 - 10:39:37 CST