Re: WebDB - Using sequences

Actually, it's easier than that.

In the default value field, use #clientid_seq

Rick

Any comments or corrections are welcome.

Frans Hovenkamp wrote in message <7pbmec$lh9$1_at_zonnetje.nl.uu.net>...
>
>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 - 17:13:54 CEST