It's not the script since is all it does is use the execute immediate functionality.
What is accompanying the script that may be keeping a statement handle?
Whatever it is try deallocating all statements to see if that will help.
In the connection component set cache statement handles to false.

Jason Wharton

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Yes I did add it during the same session. This is not an issue with
IBConsole. Why is is a problem with TIB_Script. This places serious
limitations on my scripts.

Thanks for the response.

--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
>
>
> Matt Nielsen schrieb:
> > Hello all. I have a poblem with the TIB_Script component. I
send
> > out updates to my database and have a utility that the user
executes
> > to update the database.
> >
> > Basically it just loads a physical file (update100.sql) into the
SQL
> > of the Script component and executes it using Script.Execute.
> > However, I have found that the script is not being executed the
same
> > as it is in IBConsole. Sometimes lines like:
> >
> > UPDATE APCREDIT SET DATATYPEID = 1, OVERRIDE = 1; give a string
> > conversion error and lines like:
> >
> > UPDATE APCREDIT SET DATATYPEID = 1, OVERRIDE = 1 WHERE DATATYPEID
IS
> > NULL; don't even execute at all.
> >
> > What is strange is that if I run this exact script in IBConsole
on
> > the same database everything works exactly the way it should.
> >
> > I've tried everything I can think of and it fails everytime.
> >
> > Any ideas?
>
> Did you just add the fields APCREDIT / OVERRIDE to your table
within the
> same session of IBO?
>
> If so, you have to disconnect and reconnect to the database before
> trying to update new created fields.
>
> Luc.