Try to add a commit statement after the table change. You must
commit the DDL changes before you can use them. IB Expert might
automatically commit after each statement.



ALTER TABLE EMPLOYEE
ADD INACTIVEEMPLOYEE TF;

COMMIT;

UPDATE EMPLOYEE SET INACTIVEEMPLOYEE= 'F';



trac_t

--- In IBObjects@yahoogroups.com, Quathiaski Software
<quathiaski@...> wrote:

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