Re: WebDb - automatic Sequence generator
Date: Mon, 02 Aug 1999 08:00:26 GMT
Message-ID: <7o3j6n$6mt$1_at_nnrp1.deja.com>
In article <qZ0p3.624$3X5.7493_at_insync>,
"Joet Singh" <jsingh_at_bigfoot.com> wrote:
> I have created a object to generate sequence in webdb 2.0. Now the
> question: How do I get a field to automatically populate with this
sequence
> number? I have tried triger and pl/sql statement "before displaying
page"
> but to no avail. When I do try to set a pl/sql statement "before
display
> page" I get following error WWV-01817. Any suggestions?
>
>
Supposing you want to use this sequence in a form, in the first tab
(column formatting and validation) simply place the following code in
the field "default value": #your_sequence_name.nextval
The # is essential! The next value is automatically displayed in your form.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 10:00:26 CEST