Re: Very slow FORMS!!!

Views are updateable as long as the query to create the view either references one table only or is not complex (ie containing group functions).

However, you say you are running Oracle 7 (hope your machine has no dust!!) and may not support updateable views.

If you were using Oracle 8, you can take advantage of the INSTEAD OF triggers.

There are documents on MetaLink, esp

Doc ID: Note:93691.1
Subject: (V6) BASING A BLOCK ON A VIEW (JOIN VIEW)  

Otherwise, cant think of any other way apart from what you are currently doing.

M

pochti_at_pisem.net (Maxim) wrote in message news:<73c4ea0a.0205212356.a0ac85d_at_posting.google.com>...
> Oracle 7, Forms 6.0
>
>
> There is a table Tab1(a,b,b,d,e,g,h,k)
>
> There is a view View_tab1(a,b,c,d,e) : Select a,b,c,d,e from tab1
> connect by c=prior b start with c is null
>
> I have block built on view View_tab1.
>
> But some field are not database fields
>
> I insert data into it with trigger POST-QUERY? because i want to made
> them updatable.
>
> After user changing data in that fields i insert this data into tab1
> table.
>
> And when user want to go to that record it works very slowly because
> of that non-database fields.
>
> Hoe can i made some field updatebale without making non-database
> fields and using POST-Query trigger?
Received on Wed May 22 2002 - 16:23:49 CEST