ADO MaxRecords Property

Complete Recordset Object Reference

The MaxRecords property sets or returns a long value that indicates the maximum number of records to return to a Recordset object from a query. Default is zero (which means that the provider returns all requested records).

This property is read/write on a closed Recordset and read-only on an open Recordset.

Syntax

objRecordset.MaxRecords

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))

set rs=Server.CreateObject("ADODB.recordset")
rs.MaxRecords=20
sql="SELECT * FROM Customers"
rs.Open sql,conn

rs.Close
conn.Close
%>

Complete Recordset Object Reference

Jump to: Top of Page or HOME or Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

W3Schools was converted to XHTML in December 1999