Re: Using sequences with WebDB
From: <schipper_at_frg.eur.nl>
Date: Tue, 09 Nov 1999 15:22:45 GMT
Message-ID: <809e81$l1$1_at_nnrp1.deja.com>
Date: Tue, 09 Nov 1999 15:22:45 GMT
Message-ID: <809e81$l1$1_at_nnrp1.deja.com>
In article <01bf2a23$9b455f20$8156cc8d_at_hq-tnoble95>,
"Todd Noble" <todd.noble_at_attws.com> wrote:
> I've built a table, an update form for that table, and a sequence.
> I need the <sequencename>.nextval to populate an id field in my table
on
> insert, but I don't understand how or where
> in WebDB to make that assignment.
>
> Any thoughts on how to accomplish this?
yes put schemaname.#sequencename.nextval in the initial value field.
>
> Thanks,
> Todd
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 09 1999 - 16:22:45 CET