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?

Thanks,

Matt Nielsen