Subject | Re: [firebird-support] Problem with script .. any help appreciated. |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-06-21T13:10:49Z |
> I cannot find anything new in my understanding regarding its relevance toWhen you run your script in Development Studio or other tool,
> the problem.
transaction is committed after each DDL. When you run the script in
IBScript component it isn't. Mixing DDL and DML in one transaction
always lead to errors like yours.
BTW, why you do your conversion using temporary column? Why not
change type of the column immediate?
SY, SD.