HOME HTML CSS JAVASCRIPT SQL PHP JQUERY XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO DefinedSize and ActualSize Properties


Field Object Reference 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
%>


Field Object Reference Complete Field Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE