Subject Good day. Need some help on appending data please
Author jim.rhema316
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).

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.