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.
Jim
