Easysoft dbExpress-ODBC Gateway

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

Last Reviewed:
15th January 2024

CLX SQL code appears to contain a default RowSet size of 20, which is overridden by certain 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 file or any existing dbxconnections.ini file entries. (Note that RowSetSize=0 indicates the complete RowSet.)

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)