On Fri, 10 May 2013 14:01:58 -0000, "jim.rhema316"
<jim.rhema316@...>
wrote:

> Good day.
>
> We are on Firebird 2.5.
>
> I am trying to append data into one field and I am getting an error:
> 09:42:41 [MERGE - 0 row(s), 0.000 secs] [Error Code: 335544321, SQL
> State: HY000] GDS Exception. 335544321. arithmetic exception, numeric
> overflow, or string truncation
>
> Here is the code I am trying to get to work. The SO1_Note field is
> varchar(200).
>
> Merge into FB_SALES_ORDER_FEED1
> Using sr_orderheader
> on sr_orderheader.bold_id = SO1_BOLD_ID AND
> SO1_Paymentterms = 'Amazon,'
> when matched then
> Update set SO1_Note = substring(orderdate from 1 for 10)||'

Pay

> date '|| substring(shippingreference from 1 for 19)||',';
>
> The SO1_Note field was originally varchar(25) until I ran the code below
> to alter it to become varchar(200). When I check the field after the

alter

> it reflects the varchar(200) change.
>
> Alter table FB_SALES_ORDER_FEED1 alter column so1_note type

varchar(200);

>
> Does anyone have a better way of doing this or if you can see the error
> please let me know.
>
> Thank you for your time and help with this.

What are the types of orderdate and shippingreference?

Mark