Re: I can't find the right trigger

[Quoted] Thanks for your help but I think you do not understand my problem (maybe I give you bad explain).
My problem is *NOT* to create the record in table B. The matter is to know wich value will have my sequencial column in table A. [Quoted] When forms commit my record in table A, it fires a table-trigger that call a [Quoted] sequence (SELECT seq_A.NEXTVAL into :NEW.Code FROM dual) to fill the column. [Quoted] I need to insert that value in table B. In a when-validate-record trigger on [Quoted] block A, this value is not known yet by forms and this is my problem. Am I clearer ?

Alex Filonov <afilonov_at_pro-ns.net> a écrit dans le message : 92tk3o$mdd$1_at_nnrp1.deja.com...
> Sorry,
>
> My previous answer is not complete. You use when-new-record-instance
> trigger on block a to create a new record in block b. Then you fill in
> fields in block b using when-validate-record trigger on block a.
>
> 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 Wed Jan 03 2001 - 08:26:20 CET