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