Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











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-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information