Re: WebDB - Using sequences

[Quoted] Jason Ekamper heeft geschreven in bericht <7pb18d$lck$1_at_news.cowan.edu.au>...
>Hi. I am currently involved in a university project developing a web
enabled
>application. we have chosen WebDB as our platform to develop/deploy. We
have
>created a sequence (clientid_seq) to insert the next number etc. How do we
>get the form primary key to access the predefined sequence. The tutorials
>dont seem to explain how to access the sequence through a form, only to
>create them.
>
>Any help would be appreciated.
>
Use a pre-insert trigger:
SELECT sequence_name.nextval INTO key_field FROM DUAL;
>Jason Ekamper
>Jasek_at_bigpond.com
>
>
Received on Tue Aug 17 1999 - 15:03:41 CEST