ADO Tutorial
ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO NumericScale Property
Complete Parameter Object Reference
The NumericScale property sets or returns a byte value that indicates the number of digits stored to the right side of the decimal point for a numeric value of a Field or Parameter object.
| Object | Description of the NumericScale Property |
|---|---|
| Field |
The NumericScale has read/write permissions when used to create a Recordset, but it has read-only permissions when you open an existing Recordset |
| Parameter | The NumericScale property has read/write permissions on a Parameter object |
Syntax
object.NumericScale
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).NumericScale)
rs.Close
conn.close
%>
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).NumericScale)
rs.Close
conn.close
%>
Complete Parameter Object Reference
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
