ADO Precision Property

Definition and Usage

The Precision property can be set or returned as a byte value, which represents the maximum number of digits allowed when representing a value in a Parameter or Field object.

Syntax

objectname.Precision
Object Description of Precision property
Field

For Field objects, Precision is typically read-only. However, for new Field objects added to the Fields collection of a Record, Precision is read/write only when the Field's Value property has been specified and the data provider has successfully added the new Field by calling the Update method of the Fields collection.

Parameter For Parameter objektet har Precision egenskaben læse/skrive-adgang.

Eksempel

<%
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
%>