WebDB form and sequence for unique id field

From: <akmunro_at_my-deja.com>
Date: Tue, 30 Jan 2001 14:45:07 GMT
Message-ID: <956k1g$330$1_at_nnrp1.deja.com>


[Quoted] [Quoted] I have created a WebDB form which accesses a table which contains a unique key - normal stuff. However, I don't want the user to enter values for the key, I want to get the next available value from a sequence. Where and how in the form definition do I include code which will retrieve the next sequence value and insert it into the ID field before the data is posted to the database?

Any references to on-line documentation for this would be much appreciated as Oracle's is very reluctant to give up its secrets!

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 30 2001 - 15:45:07 CET

Original text of this message