Sorry Helen, but do I understand correctly .. setting Auto Commit in IB_Script has no effect as in :
IB_Script17.SQL.Insert(0,'SET AUTODDL on;');

If that is so, will Commit Work; do the trick after each statement.
I tried that too, and I still had the error.
Thanks
Adrian

>When you run a script in isql you can use SET AUTO to switch autoddl off and on. It's on by default. When it's on, each DDL statement is committed upon >execution. And that's what you *need* when running scripts containing DDL statements. But that's in isql.

>You had *your* problems running an IB_Script, which is NOT isql. It is a component that lets you run a batch of statements in a file. So it performs a similar kind of >task to isql's INPUT command (with added tricks) but it's not isql's INPUT command and it doesn't autocommit the statements unless you make it so.

[Non-text portions of this message have been removed]