Hello,
 
Do you take a look of the charset you use for this database...
If you place a char in the sql that is not supported by the charset, you could have such message...
May be replacing % in the sql this could solve your problem.
 
Bye bye..


________________________________
De : Michel LE CLEZIO <mlcvista@...>
À : "IBObjects@yahoogroups.com" <IBObjects@yahoogroups.com>
Envoyé le : Jeudi 28 juin 2012 9h34
Objet : Re: [IBO] Insert error



 

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 <mailto:jwcane%40enw-ltd.com>
À : mailto:IBObjects%40yahoogroups.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]




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