Hello,
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)
 
Bye...
 
NB why you place ^ at the end ?
 


________________________________
De : jwcane2003 <jwcane@...>
À : IBObjects@yahoogroups.com
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)
VALUES("Theo","Jones","6105","2101","Yes","mailto:jones%40aol.com","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.




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