Why do I only get 20 rows back from a dbExpress query?

CLX SQL code appears to contain a default RowSet size of 20, which is overridden by some dbExpress drivers.

To ensure that the Easysoft dbExpress-ODBC Gateway also overrides this default, specify the number of rows to be returned in the RowSetSize attribute of your dbxdrivers.ini or dbxconnections.ini file. Note that RowSetSize=0 means retrieve the whole RowSet.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•