ADODB Object

NumericScale

 
Syntax
 
byte = parameterobject.NumericScale
 
Description
Sets or returns a byte value that is the number of digits allowed to theright of the decimal point for a numeric Field object.
 
The NumericScale property sets or returns a byte value that defines how many digits are stored to the right side of the decimal point for a numeric value (number) for a Parameter object. The number of digits stored on the right side is also referred to as the scale of the number.
See Also
Field.NumericScale, Parameter, Precision.
Example
 
For Each objParameter In objCommand.Parameters
   Debug.Print objParameter.NumericScale 
   Debug.Print objParameter.Precision 
Next