Hi Everyone.

We have been struggling with this for a few hours and
can't find any documentation that leads us to an answer.

We have a domain called TF (char(1)) with a check [VALUE IN ('T','F')]

When we run these script lines in TIB_Script (loaded from a file)

ALTER TABLE EMPLOYEE
ADD INACTIVEEMPLOYEE TF;

UPDATE EMPLOYEE SET INACTIVEEMPLOYEE= 'F';


We get the following error messages.

-------------------------------------------------------
SQL ERROR CODE:-413

SQL ERROR MESSAGE:
Overflow occurred during data type conversion.
UPDATE EMPLOYEE SET INACTIVEEMPLOYEE= 'F'
ISC ERROR CODE:335544334

ISC ERROR MESSAGE:
conversion error from string "F"

STATEMENT:
TIB_DSQL: "<TApplication>.frmUpdaterMain.IB_Script1
.<TIB_DSQL>."

-------------------------------------------------------

This script was tested in IBExpert Script Executive and
It works fine there.

Please point us in the right direction or perhaps a
Hint as to what to do to solve this issue.

Dayna,
Quathiaski Software for
Liquid Software Designs.