At 10:15 PM 17/04/2004 -0400, you wrote:

>Hello,
>
>Is it possible to make sure that IBScript does not commit DDL until I
>explicitly call Commit on the associated Transaction? I am writing a
>utility to update customers db remotely from a downloaded script file which
>is parsed and tested against the customer's current database "version". I
>want to be able to roll back everything in the event of an error in the
>process.

AFAIK, it never autocommits unless you set Autocommit or ServerAutocommit
true on the transaction. Just be sure you take care of them, even perhaps
explicitly setting them off before the StartTransaction.

But if you wanted to absolutely sure, do both that and include a statement
preceding all of the DDL statements:
SET AUTODDL OFF;

Helen