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

Valeri:

[Quoted] [Quoted] I already tried this, and the sequence seems to be working (I checked it [Quoted] 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?

[Quoted] 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
Received on Fri Feb 04 2000 - 16:29:08 CET