INFO
Applies To:
ITScriptNet V1/V2
Microsoft Access, Microsoft SQL Server, and other databases can support the Decimal data type. ITScriptNet can store collected data in this field. You must set the field options correctly in order to prevent problems.
DETAILS
Using the Decimal data type in Microsoft Access requires setting the Scale factor to the maximum number of decimal places that could be used. If the number of decimal places exceed the number specified in the Scale factor, you will receive an ADO Multi-Step error and the record will not be saved.
Numbers stored in the Decimal data type are limited to 15 digits without rounding.
This article last updated:
1/1/2009 12:00:00 AM