HELP: Sequences and Items
From: Anil <aarhemtu_at_cayley.uwaterloo.ca>
Date: Fri, 10 Jun 1994 20:53:35 GMT
Message-ID: <Cr78pB.LCD_at_undergrad.math.uwaterloo.ca>
Date: Fri, 10 Jun 1994 20:53:35 GMT
Message-ID: <Cr78pB.LCD_at_undergrad.math.uwaterloo.ca>
I have a SEQUENCE set up on Oracle 7. It's simply a four didgit number which
I would like to concatenate with the current year and place the new 8 didgit
number into and item in Forms 4.0.
I know I can use :SEQUENCE.seq_name.nextval in the default field of an item,
but I can't figure out how to get a sequence number into a trigger so I
can prefrom the concatenation.
Please HELP,
Anil