Hello,

Also see if you have the good charset for your database...(if you use a char in the sql that is not supported by the charset...you will have such message). And may be the % inside the sql is the cause of the message...

Bye.
Mikey

--- In IBObjects@yahoogroups.com, Michel LE CLEZIO <mlcvista@...> wrote:
>
> 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]
>