Subject Re: [IBO] Insert error
Author Michel LE CLEZIO
Do you have compare size of field and length of string you try to insert ?
If field's size is smaller than string, that could be the reason...
(All the field must be char or varchar...with a length)
NB why you place ^ at the end ?

De : jwcane2003 <jwcane@...>
À :
Envoyé le : Jeudi 28 juin 2012 2h23
Objet : [IBO] Insert error


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)

When I run it, IB_SQL returns the following:

ISC ERROR CODE:335544321

arithmetic exception, numeric overflow, or string truncation
string right truncation

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.

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