Subject Re: [ib-support] Basic question
Author Helen Borrie
At 07:11 PM 6/05/2003 -0500, you wrote:
>Hi,
>
>It's a basic Firebird question ... but how can I set the flag to ensure an
>autocommit after every SQL statement in a script?

For a DDL script (ones that contains statements to
create/recreate/alter/drop objects or SET conditions) just use the statement

SET AUTO DDL ON;
or
SET AUTO; (which acts as an on/off switch)

This doesn't affect DML statements. You need to include COMMIT [WORK]
statements at the right places in the script for this.

heLen