Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Resultset always 1000 rows
Elena daSilva
2008-03-21 15:11:45.0
Hello,

I am try to query a table with 7000 rows, and I only get a resultset with 1000.
I have SetMaxRows(0), so the resultSet can be of unlimited size, and yet I only get 1000 rows. My Query is "Select * from Patients", because I need to read the entire table.

Is there a limit set in the Access Library that is not allowing more than 1000 rows?
If there is no limit, how can I access all 7000 rows?
OR
How can I get the first 1000 and then the next 1000 and then 1000 more until all 7000 are read?

Thank you very much for your help.

Sincerely,
Elena daSilva
Re:Resultset always 1000 rows
HXTT Support
2008-03-23 04:18:11.0
Yeah. It's an evaluation limitation at here.
Re:Re:Resultset always 1000 rows
Elena
2008-03-24 04:51:52.0
Thank you for the answer!!
I forgot to download the full version after buying the license.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap