Tutorials References Menu

ADO Precision Property


❮ Complete Parameter Object Reference

The Precision property sets or returns a byte value that is the maximum number of digits allowed when representing numeric values in a Parameter or Field object.

Object Description of the Precision Property
Field

The Precision property is normally read-only on a Field object, but for new Field objects that have been added to the Fields collection of a Record, it is read/write after the Value property for the Field has been specified and the provider has successfully added the new Field by calling the Update method of the Fields collection

Parameter The Precision property has read/write permissions on a Parameter object

Syntax

objectname.Precision

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn

response.write(rs.Fields(0).Precision)

rs.Close
conn.close
%>

❮ Complete Parameter Object Reference