I have to do the conversion with a temp column, as the database is
populated.
I will try leaving Auto commit off, and commit after each statement, to see
if that helps.

Regards

Adrian

----- Original Message -----
From: "Dimitry Sibiryakov" <sd@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, June 21, 2009 3:10 PM
Subject: Re: [firebird-support] Problem with script .. any help appreciated.


>> I cannot find anything new in my understanding regarding its relevance to
>> the problem.
>
> When you run your script in Development Studio or other tool,
> 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.
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>