New Search    ITScriptNet Home
  ITScriptNet Knowledge Base
Article ID: 10080
INFO: How to use the Decimal data type.
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.

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.
 
 
Please help us improve the Knowledge Base by rating this article.
Not Helpful Very Helpful
(c) 2000-2010 Z-Space Technologies, Inc. All Rights Reserved.