The following insert command is an example of what I would like to use to enter dummy data into my database for testing:

INSERT INTO residents (First, Last, Bldg, Unit, cbRelease, Email, lbOwnRent)
VALUES("Theo","Jones","6105","2101","Yes","jones@...","Own")^

When I run it, IB_SQL returns the following:

ISC ERROR CODE:335544321

ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation
string right truncation

STATEMENT:
IB_Script.<no name>(TIB_DSQL)

I induced a field name error in the last column and generated an appropriate error. Hence I know that the truncation error applies to the VALUES(...) part of the query.

Any ideas appreciated.