(unknown charset) Re: creating text items as runtime in forms 6.0

i would suggest you upgrade your version of forms. (patchset 10 and above is a safe bet).

you certainly CAN insert into a view. And have been able to do so as long as I can remember (and that is a very long time).

even with an oracle 7 database overriding the insert/update/delete triggers with your own will get around it. [maybe you need to recode that form]  : )))

poor you. there was a bug introduced into a version of forms 6 which did not allow you insert or update a view. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=17906.996

if you attempt to insert into a view whose columns are from multiple tables you must override the insert / update / delete triggers on the form.

Luc Bosman wrote:

> On Wed, 04 Dec 2002 14:48:59 +0100, Luc Bosman
> <l.bosman_xspamx_at_iile.be> wrote:
>
> >On Wed, 04 Dec 2002 13:08:01 +0000, NinjaToy
> ><LCIYQBBEQVFA_at_spammotel.com> wrote:
> >
> >>a spreadsheet format only presents a problem to forms when
> >>both x and y dimensions vary.
> >
> >it was the case
> >
> >>if you took variable sized data into a form from a spreadsheet
> >>format the argument would still be the same.
> >>why use a non basetable block when you could use
> >>views or procedures to base the block on?
> >
> >forms 4.5 16 bits  and a view can not be updated in oracle 7
> >
>
> even in Forms6 my dear myself
> FRM-4062 cannot insert or update data in a view
> --
> Luc Bosman
> DEV/2000 Software Engineer
> Database & Network Administrator
> l.bosman_at_iile.be
>  ----------------------------------------------------
> |  -°)                                          (°-  |
> |  /\\  Linux the choice of the GNU generation  //\  |
> | _\_v                                          v_/_ |
>  ----------------------------------------------------

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