Re: Oracle Forms: Need advice

From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Wed, 6 Aug 2003 16:24:35 +0100
Message-ID: <bgr6me$1eqt$1_at_news.icl.se>


[Quoted] [Quoted] "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 [Quoted] problem though on non-db items. Received on Wed Aug 06 2003 - 17:24:35 CEST

Original text of this message