Subject Re: [firebird-support] RE: SCRIPT ERROR
Author Milan Babuskov
Helen Borrie wrote:
> I am saying that the script does stop executing (fails) at the point of the
> error. If autoddl is on or commits were called on previous statements, the
> previous statements would "stick"; but the failed statement and all after
> it would not be executed, i.e. the script stops executing.

In my experience that is not the case. Script:

create table a ( x integer);
commit;
create table a ( x integer);
commit;
create table b ( x integer);
commit;

isql -i script.sql

Table "b" gets created even if statement before it failed.

--
Milan Babuskov
http://fbexport.sourceforge.net