The Precision property sets or returns a byte value that is the maximum number of digits allowed when representing numeric values in a Para...
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", connresponse.write(rs.Fields(0).Precision) rs.Close conn.close %> |
Goto ADO Parameter Object complete list
