Hi, For MS SQL you have to use GO between statements, might be same for MS Access Vid --- Garry Steedman <gs@styrax.com> wrote:
Harlow,
IIRC it depends on the ODBC/RDBMS implementations: check your docs for these and you should be able to work out if they support multiple sql statements...
g
On 18 Dec 2001, at 9:43, Harlow Pinson wrote:
From: "Harlow Pinson" <hpinson@indepthl.com> To: Vid Bijelic <zoops4@yahoo.com> Subject: Re: [Zope] Multiple SQL statements in a single ZSQL method? Send reply to: hpinson@indepthl.com Copies to: zope@zope.org Priority: normal Date sent: Tue, 18 Dec 2001 09:43:56 -0700
Just place ; at the end of sql statement.
When I do that, I get an ODBC error:
Error Type: sql.error Error Value: ('37000', -3517, '[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.')
Here's my very simple SQL statement, in the ZSQL method:
INSERT INTO tblUsers VALUES ( 5 );
INSERT INTO tblParents VALUES ( 5 );
The first statement by itself works fine.
Harlow Pinson Indepth Learning Email: hpinson@indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
+-------------------------------------------+ Garry Steedman mailto:gs@styrax.com Styrax Associates http://www.styrax.com/
"The Good Man has no shape." +-------------------------------------------+
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
__________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com