[thelist] probably simple SQL question

[Chris Blessing]

You got it.  Use the semicolon to separate multiple sql statements.
Example:

sqlStr = "INSERT INTO myTable (field1, field2) VALUES ('John', 'Moe');" &_
"INSERT INTO my2ndTable (field1, field2) VALUES ('Well', 'Yeah')"

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Marc Seyon
Sent: Thursday, January 17, 2002 7:04 PM
To: thelist at lists.evolt.org
Subject: [thelist] probably simple SQL question


Evolters with more knowledge of SQL than me (most everyone),

Am wondering about this. If I need to insert records into two (or more)
tables in a database is there a straightforward way to do this?

Along the lines of "Insert Into TableA xyz; Insert Into TableB zyx"

Hoping someone understands what I'm attempting to do and it's not too
impossible.

Thanks.
-marc

--
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !