Re: How do you tie a sequence to a form item??

From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Fri, 04 Feb 2000 19:37:01 +0300
Message-ID: <389B002D.45B2FA0D_at_dd.ru>


Hi Richard,

PRE-INSERT trigger will fire only by Save command.

So press [F10] and see next value in your field...

Hope that helps.

Richard Hollingsworth wrote:
>
> Valeri:
>
> I already tried this, and the sequence seems to be working (I checked it
> agter each run) but the value still does not show up on the form. Is
> there anything else I need to do besides the trigger ( say to the
> properties of the field ) or something?
>
> Thanks again,
>
> Richard H.
>
> Valeri Sorokine wrote:
> >
> > Joe wrote:
> > >
> > > Richard,
> > >
> > > In a trigger such as the WHEN-NEW-FORM-INSTANCE trigger:
> >
> > No, you'd better use it in PRE-INSERT trigger...
> >
> > > SELECT myseq.nextval INTO :block.field
> > > FROM dual;
> > >
> > > Hope this helps.
> > >
> > > Joe
> > >
> > > Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> wrote in
> > > message news:3899A5E0.BE95FB7A_at_hsv.boeing.com...
> > > > Hi folks. Thanks for reading this.
> > > >
> > > > I want to create a sequence, and then use it to auto-populate a counter
> > > > (number field) on my form (D2K 2.1).
> > > >
> > > > I've created the sequence, but I can't figure out how to tie it to the
> > > > number field on my form.
> > > >
> > > > Thanks for any help...
> > > >
> > > > Richard Hollingsworth
> >
> > --
> > Valeri Sorokine
> > Oracle Certified Application Developer, Rel.2
> > ProSoft, Russia, Moscow, Information Systems Division
> > Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
> > E-mail: vsorokin_at_dd.ru ; http://www.dd.ru

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru
Received on Fri Feb 04 2000 - 17:37:01 CET

Original text of this message