ADO Type Property
Complete Parameter Object Reference
The Type property sets or returns a DataTypeEnum value that indicates the type of a Parameter, Field, or a Property object.
| Object | Description of the Type Property |
|---|---|
| Parameter | The Type property has read/write permissions on a Parameter object |
| Field | The Type property is read/write, with one exception; for new Field objects that are added to the Fields collection of a Record, this property is read-only before the Value property has been set and before the provider has called the Update method of the Fields collection |
| Property | The Type property is read-only for a Property object |
Syntax
objectname.Type
Example - For a Field object
<%
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).Type)
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).Type)
rs.Close
conn.close
%>
Example - For a Parameter object
<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para
%>
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para
%>
Example - For a Property object
<%
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
set prop=Server.CreateObject("ADODB.Property")
'Display the property attributes of the Orders Table
for each prop in rs.Properties
response.write("Attr:" & prop.Attributes & "<br>")
response.write("Name:" & prop.Name & "<br>")
response.write("Value:" & prop.Value & "<br>")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
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
set prop=Server.CreateObject("ADODB.Property")
'Display the property attributes of the Orders Table
for each prop in rs.Properties
response.write("Attr:" & prop.Attributes & "<br>")
response.write("Name:" & prop.Name & "<br>")
response.write("Value:" & prop.Value & "<br>")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
DataTypeEnum Values
Specifies the data type of a Field, Parameter, or Property object
| Constant | Value | Description |
|---|---|---|
| adEmpty | 0 | No value |
| adSmallInt | 2 | A 2-byte signed integer. |
| adInteger | 3 | A 4-byte signed integer. |
| adSingle | 4 | A single-precision floating-point value. |
| adDouble | 5 | A double-precision floating-point value. |
| adCurrency | 6 | A currency value |
| adDate | 7 | The number of days since December 30, 1899 + the fraction of a day. |
| adBSTR | 8 | A null-terminated character string. |
| adIDispatch | 9 | A pointer to an IDispatch interface on a COM object. Note: Currently not supported by ADO. |
| adError | 10 | A 32-bit error code |
| adBoolean | 11 | A boolean value. |
| adVariant | 12 | An Automation Variant. Note: Currently not supported by ADO. |
| adIUnknown | 13 | A pointer to an IUnknown interface on a COM object. Note: Currently not supported by ADO. |
| adDecimal | 14 | An exact numeric value with a fixed precision and scale. |
| adTinyInt | 16 | A 1-byte signed integer. |
| adUnsignedTinyInt | 17 | A 1-byte unsigned integer. |
| adUnsignedSmallInt | 18 | A 2-byte unsigned integer. |
| adUnsignedInt | 19 | A 4-byte unsigned integer. |
| adBigInt | 20 | An 8-byte signed integer. |
| adUnsignedBigInt | 21 | An 8-byte unsigned integer. |
| adFileTime | 64 | The number of 100-nanosecond intervals since January 1,1601 |
| adGUID | 72 | A globally unique identifier (GUID) |
| adBinary | 128 | A binary value. |
| adChar | 129 | A string value. |
| adWChar | 130 | A null-terminated Unicode character string. |
| adNumeric | 131 | An exact numeric value with a fixed precision and scale. |
| adUserDefined | 132 | A user-defined variable. |
| adDBDate | 133 | A date value (yyyymmdd). |
| adDBTime | 134 | A time value (hhmmss). |
| adDBTimeStamp | 135 | A date/time stamp (yyyymmddhhmmss plus a fraction in billionths). |
| adChapter | 136 | A 4-byte chapter value that identifies rows in a child rowset |
| adPropVariant | 138 | An Automation PROPVARIANT. |
| adVarNumeric | 139 | A numeric value (Parameter object only). |
| adVarChar | 200 | A string value (Parameter object only). |
| adLongVarChar | 201 | A long string value. |
| adVarWChar | 202 | A null-terminated Unicode character string. |
| adLongVarWChar | 203 | A long null-terminated Unicode string value. |
| adVarBinary | 204 | A binary value (Parameter object only). |
| adLongVarBinary | 205 | A long binary value. |
| AdArray | 0x2000 | A flag value combined with another data type constant. Indicates an array of that other data type. |
Complete Parameter Object Reference
