Phillips
|
| Posted: 03/12/2002, 7:27 AM |
|
Hi,
I'm trying to insert one from into three different table. From the FAQ on
CC they said this can be done w/ a SQL script.
Would someone please walk me through this step of where the SQL script is
insert?? or a betterway to insert into multiple tables.
Thanks,
|
|
|
 |
Glenn Holden
|
| Posted: 03/12/2002, 10:06 AM |
|
I would do this by adding three SQL statements to the Before Insert or After
Insert events for the form, depending on where and when the information will
be in the original table. How the SQL is constructed or sent depends on
your app server and database software.
For PHP with MySQL each statement would be something like:
$db->query("insert table_X (col_1, col_2, col_3) select col_A, col_B, col_C
from tbl_Y where col_A = 'something'");
"Phillips" <fdiskboy@msn.com> wrote in message
news:a6l6on$ig9$1@news.codecharge.com...
> Hi,
>
> I'm trying to insert one from into three different table. From the FAQ on
> CC they said this can be done w/ a SQL script.
>
> Would someone please walk me through this step of where the SQL script is
> insert?? or a betterway to insert into multiple tables.
>
> Thanks,
>
>
>
|
|
|
|
|
