Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.258
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol 5.0.257
  HXTT DBF 7.1.259
  HXTT Excel 6.1.261
  HXTT Json 1.0.229
  HXTT Paradox 7.1.257
  HXTT PDF 2.0.257
  HXTT Text(CSV) 7.1.257
  HXTT Word 1.1.257
  HXTT XML 4.0.258
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)

HXTT ACCESS
Resultset always 1000 rows
Elena daSilva
2008-03-21 15:11:45
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
Yeah. It's an evaluation limitation at here.
Re:Re:Resultset always 1000 rows
Elena
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




Google
 

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