Re: form6i/data item/trigger

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 Wed Oct 02 2002 - 22:08:23 CEST