[Zope] Help with multiple SQL statements in Interbase?

[Jason.Jones@awl.com]

I have an Interbase 6.0 database on Win32 and I'm using the 0.9.2 version of the gvidb, but I'm running into problems with Z SQL queries like the following:

insert into users (username,pword,email,lastname,firstname,chrome)
values(<dtml-sqlvar username type="string">,
<dtml-sqlvar expr="mkpword(password)" type="string">,
<dtml-sqlvar email type="string">,<dtml-sqlvar lastname type="string">,
<dtml-sqlvar firstname type="string">,
<dtml-sqlvar chrome type="string">)
<dtml-var sql_delimiter>
insert into users_roles (UID, ROLEID)
values(gen_id(UID_GEN,0), <dtml-sqlvar user_role type="string">)

The SQL looks right and the first part of the query (before the delimiter) is executed and committed. The second part (which adds a user's role) never gets submitted. Is there a problem with sending multiple SQL statements to interbase in the same method? If so, is there a workaround, these need to go in the same transaction to insure that gen_id gives me the correct value.

Thanks,

Jason Jones
jason.jones@awl.com