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

You can use sequences in webdb by specifying #myseq.nextval as the default value for a field.
Note that it prepopulates the field when the form is displayed.

You should be able to use dynamic LOVs to select the keys from tables A and C.

I don't think you can get webdb to perform updates on mode than one table at a time, other than by using master-detail forms, which have their own quirks and are limited to (2) tables.

You might be able to get creative and use database triggers to perform some of the work. webdb generally rereads the records via rowid after saves, so autofilled fields.

Peter

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:27:25 CEST