Re: Oracle Forms: Need advice

Daniel,

[Quoted] There was no mention of parent-child relationships !!!! This is a form based upon a SINGLE block. Also, I did use the built in wizard !!!

So, the only thing that I am doing is obtaining data from foreign tables into non-database fields.

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:1060199556.14591_at_yasure...
> Dave Williams wrote:
>
> >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 ?
> >
> >Thanks in advance.
> >
> >
> >Dave.
> >
> >
> Sounds to me like rather than using the built-in wizard to configure
> parent-child relationships and automate this you invested in writing
> your own.
>
> I'd suggest dropping your triggers and using the native functionality:
> It works.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Aug 06 2003 - 23:36:47 CEST