PROPERTY: Field::Precision

byte = fieldobject.Precision
 
The Precision property sets or returns a byte value that defines the maximum number of digits that a number (numeric value) can have in a Field object. This maximum number is also referred to as the degree of precision.
 
Normally, Precision is read-only for a Field object. However, after the Value has been set for the Field object and after a subsequent Update method call for a Fields collection, it can become read/write.
 
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