Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  Buy Now
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
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
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

Resultset always 1000 rows
Elena daSilva
2008-03-21 15:11:45

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?
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.

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

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap