Additionally, remember that if they are all related, and a primary key is
created from the first insert, then you will have to requery the table after
the insert to find the max record id for use in other insert statements.
-Original Message-
From: Matthew W Jones [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] a SQL question
yes
wrap them in a transaction block, and commit if they all worked, or rollback
if any failed
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] a SQL question
I need to insert data into multiple tables that are related. Every example
of an insert statement I have seen only inserts info into one table. Do I
need to write 4 different INSERT statements?
A.
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
