PROPERTY: Field::NumericScale

byte = fieldobject.NumericScale
 
The NumericScale property returns a byte value that defines how many digits are stored to the right side of the decimal point for a numeric value (number) of a Field object. The number of digits stored on the right side is also referred to as the scale of the number.
 
The NumericScale property has read/write permission when being used to create recordsets, but converts to read-only when you open an already created recordset.
 
Code (VBScript):
For Each objField In rsData.Fields
   Response.Write objField.NumericScale & VBCRLF
   Response.Write objField.Precision & VBCRLF
Next

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information