Re: Oracle Forms: Need advice

[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 ?

If you modify item values in a block programatically or interactively after [Quoted] a query, such as during a post-query trigger, you will mark the block/record [Quoted] status as 'changed' and you will be prompted to save those changes upon exit, that is the way block functionality works. If you want to simply display values in a form, say programatically from a post-query trigger, use [Quoted] 'display' items instead of 'text' items, this doesn't affect the status of the block if they are modified. Received on Thu Aug 07 2003 - 10:52:57 CEST