[Zope] Multiple SQL statements in a single ZSQL method?

[Harlow Pinson]

>> 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