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.