ADO DefinedSize and ActualSize Properties
 Complete Field Object Reference
The DefinedSize property returns a long value that indicates the
defined size of a field (in bytes).
The ActualSize property is a read-only property. It returns a long value that
indicates the actual length of a field's value. If ADO cannot determine the length of the Field object's value,
it returns adUnknown.
The DefinedSize property defines how long a field's value can be, while ActualSize
tells how long it really is.
Syntax
|
objrs.Fields(number).DefinedSize
objrs.Fields(number).ActualSize
|
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).DefinedSize)
response.write(rs.Fields(0).ActualSize)
rs.Close
conn.close
%>
|
Complete Field Object Reference
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|
HOME
Printer friendly page
