SHIPEASY

None Defined

Conversion error in UPS when entering delivery number. nvarchar to int

Comma in the quantity field.

Bad entry in the quantity field: “1,200”.

              Please run this update statement against your database

update [@TWBS_UPS_Lines] set U_quantity = replace(U_quantity, `,`, ``) where charindex(`,`,u_quantity ) > 0

Solution

19 Feb 2009