Re: Oracle Forms: Need advice

From: Dave Williams <davetati_at_dsli.com>
Date: Wed, 6 Aug 2003 12:11:00 -0400
Message-ID: <jBSdncrmUN0FtayiXTWJhw_at_dsli.com>


Alan,
Not a read only form...but I want the users to query (obviously) as well as enter.

Dave.
"Alan Mills" <Alan.Mills_at_xservices.pants.fujitsu.com> wrote in message news:bgr6me$1eqt$1_at_news.icl.se...
>
> "Dave Williams" <davetati_at_dsli.com> wrote in message
> news:YvucnQm_Dt6cm6yiU-KYgg_at_dsli.com...
> > All,
> >
> > Need some advice on what the best way to handle the following situation
> is.
> >
> > I have a form that is based upon a DB table. There are about 4 columns
> that
> > are id's and link to other tables. I have a post_query trigger that
> obtains
> > the data from the relevant tables and puts them into text fields on the
> > form. So, the id fields are never displayed. If a query is run and I
> then
> > elect to close the form it asks if I want to save the data, assuming
here
> > that since the data was loaded into text fields Oracle Forms is now
> thinking
> > that the data has been modified.
> >
> > What I have done in the past is to use the set_record_property in the
> > post_query table.
> >
> > Is there a better way of handling this ?
> >
>
> Sounds like a read only form. Create a view and query on that.
>
> I've been away from Forms for a couple of years. I'm surprised you get
this
> problem though on non-db items.
>
>
Received on Wed Aug 06 2003 - 18:11:00 CEST

Original text of this message