Re: I can't find the right trigger

Apparently, you are trying to select values from table a when inserting into table b. Triggers can't help here. Forms don't change database objects until you issue post or commit.

Now, solution.
Do not insert into table. Create Forms block for table b and create record in this block every time you create record in block a. The best place for it is when-new-record-instance trigger.

In article <92sr6d$c8$1_at_wanadoo.fr>,
  "Jérôme PERRET" <jperret_at_freesurf.fr> wrote:
> Hi,
>
> I'm developping with "Oracle Forms Builder v 6.0.8.8.0" and want to
 insert
> in table B when user create a record in table A that is the main table
 of my
> form. I need to insert in B a value from a column in table A. This
 value is
> sequencial with a trigger based on table A like this :
>
> IF INSERTING THEN
> SELECT seq_A.NEXTVAL into :NEW.Code FROM dual;
>
> My problem is that all triggers i've tried don't know the value of my
 column
> because the trigger based on table A fire after them.
>
> How can I do this ?
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 23:12:30 CET