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

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