> 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>."

Try putting a commit in between them.

ALTER TABLE EMPLOYEE
ADD INACTIVEEMPLOYEE TF;

COMMIT;

UPDATE EMPLOYEE SET INACTIVEEMPLOYEE= 'F';

Let me know,
Jason Wharton