Hi there.



Thanks so much for the prompt reply.



The error changed to this.



--> SQL Message: SQL ERROR CODE:-607



SQL ERROR MESSAGE:

This operation is not defined for system tables.

--> SQL Text: COMMIT

--> Error text: ISC ERROR CODE:335544351



ISC ERROR MESSAGE:

unsuccessful metadata update

object PATIENT is in use



STATEMENT:

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





There is no one connected to the db server. And no references to the
PATIENT table in the script being run.

I have no idea how to proceed.



Dayna.









_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Jason Wharton
Sent: August 10, 2007 11:54 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] RE: Yahoo! Groups: Welcome to IBObjects. Visit today!

> 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





[Non-text portions of this message have been removed]