Writing to multiple tables with WebDb
From: ceophs <ceophs_at_my-deja.com>
Date: Fri, 24 Mar 2000 12:29:40 GMT
Message-ID: <8bfn3b$g88$1_at_nnrp1.deja.com>
[Quoted] I need to produce a form that will write the data entered in the fields [Quoted] to several tables, some of which are join/link tables, using Dynamic LOVs. What is the best way to do this? Master / Detail won't work as it only populates two tables.
I presume the best way is to create either a procedure, or view, that [Quoted] will write the data to multiple tables, and then build a form on it? I also want to know is it possible to use the concatenate symbol || and outer join (+) in the select SQL for Dynamic Lovs by replacing them with their html equivalents, e.g.
e.g. | | for the || symobl.
( +) for (+)
All suggestions greatly appreciated,
Date: Fri, 24 Mar 2000 12:29:40 GMT
Message-ID: <8bfn3b$g88$1_at_nnrp1.deja.com>
[Quoted] I need to produce a form that will write the data entered in the fields [Quoted] to several tables, some of which are join/link tables, using Dynamic LOVs. What is the best way to do this? Master / Detail won't work as it only populates two tables.
I presume the best way is to create either a procedure, or view, that [Quoted] will write the data to multiple tables, and then build a form on it? I also want to know is it possible to use the concatenate symbol || and outer join (+) in the select SQL for Dynamic Lovs by replacing them with their html equivalents, e.g.
e.g. | | for the || symobl.
( +) for (+)
All suggestions greatly appreciated,
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 24 2000 - 13:29:40 CET