Re: How do you tie a sequence to a form item??
From: Joe <Joseph.Cheevers_at_dartmouth.edu>
Date: Thu, 3 Feb 2000 14:23:30 -0500
Message-ID: <87ckjk$pft$1_at_merrimack.Dartmouth.EDU>
Date: Thu, 3 Feb 2000 14:23:30 -0500
Message-ID: <87ckjk$pft$1_at_merrimack.Dartmouth.EDU>
Richard,
[Quoted] In a trigger such as the WHEN-NEW-FORM-INSTANCE trigger:
SELECT myseq.nextval INTO :block.field
[Quoted] 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
Received on Thu Feb 03 2000 - 20:23:30 CET