Subject | Re: [ib-support] Basic question |
---|---|
Author | Helen Borrie |
Post date | 2003-05-07T00:17:06Z |
At 07:11 PM 6/05/2003 -0500, you wrote:
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
>Hi,For a DDL script (ones that contains statements to
>
>It's a basic Firebird question ... but how can I set the flag to ensure an
>autocommit after every SQL statement in a script?
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