Re: form6i/data item/trigger

[Quoted] Wrong. I've successfully achieved exactly this. There is a property of individual items in Forms 6 (presumably in Forms 6i as well) to return any value populated by db triggers on insert (and presumably update triggers). It's been a while (not actually done any Forms for nearly two years now!) and I don't have Forms in front of me so can't quote the exact name of the property. Select each property in turn and hit F1 (in Windows at least) to get the help. It is there and it did work for me. Might have the word 'return' in the property name. That sounds familiar.

So there should be no need to repeat the code in theDB trigger in your Form. Dig a little further and you'll find it.

Alan

[Quoted] "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D9B521F.D53C558E_at_exesolutions.com...
> Daud wrote:
>
> > Hi
> >
> > I have 5 table-bound text fields in my form. I created a 'before
> > insert' trigger for the table to populate one of the fields.
> > Everything works fine except that when I insert a new record and
> > commit, the value that the trigger inserted into the field in the
> > table does not show up in my form. I need to re-query before it will
> > show up.
> > How do I get around it?
> >
> > thanks
> > Daud
>
> You don't ... you can't.
>
> If you want the value in the form first ... then drop the trigger and do
> the following:
>
> SELECT sequence_name.NEXTVAL
> INTO :block_name.item_name
> FROM dual;
>
> Daniel Morgan
>
Received on Thu Oct 03 2002 - 10:12:59 CEST