Re: WebDB form and sequence for unique id field

I never did figure out how to do that in the form. I ended up creating a 'before insert' trigger on the table to generate the keys.

akmunro_at_my-deja.com wrote:
>
> 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 - 16:25:25 CET