Re: WebDB: insert values in n:m relationship in one form

From: Gavinator <Gavinator_nospam_at_home.com>
Date: Fri, 15 Oct 1999 13:25:26 GMT
Message-ID: <38072bfe.1467069_at_news.videon.wave.ca>


When creating/editing the form, go to the 'Column Formatting and Validation' tab. For the default value enter #my_seq.nextval The # Is important.

Hope this helps,

Gavinator

On Fri, 15 Oct 1999 08:03:54 GMT, todecker_at_my-deja.com wrote:

>I've got a n:m relationship
>=> 3 physical tables A -< B >- C
>Each table has an ID created by a sequence.
>My idea was to have a dropdown-list filled with
>values from table A and a form with input fields
>for table C. Is there any possibility to insert
>values into table C and B (the relationship to A)
>just by clicking on a "submit"-button?
>
>How can I automatically insert the sequence in
>WebDB? I've read that Oracle Designer has the
>ability to generate a trigger for that. But I do
>not have Designer, so how must the trigger look
>like?
>
>Thanks in advance!!!!
>
>Torben
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 15 1999 - 15:25:26 CEST

Original text of this message