ShipRush ADO: Programming Notes

For numeric data types, the string representation will be used going to and from ShipRush. For example, a SQL Server Numeric type must be declared in the database with appropriate precision. For saving the shipment cost, a default numeric declaration will cause truncation of data after the decimal place, as ShipRush will pass a string of the cost, and SQL Server will truncate off the digits after the decimal place when storing the data.

Using the Cast and related operators in SQL Server will allow data to be passed from ShipRush to any data type.

In SQL Server, the Money data type is commonly used, and should serve well for storing shipment cost. If using the numeric data type, it would typically be declared as follows:

numeric(10,4)

e.g.

alter table orders add ShipmentCost numeric(10,4)