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

Easysoft dbExpress-ODBC Gateway

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

Article :	00694
Last Reviewed :	19th July 2005
Revision :	1

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, add a numeric value which represents the number of rows to be returned (where 0 indicates the complete RowSet) to the RowSetSize= attribute of your dbxdrivers.ini file and any existing dbxconnections.ini file entries.

Applies To

Products
- Easysoft dbExpress-ODBC Gateway

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft dbExpress-ODBC Gateway

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

Applies To

Knowledge Base Feedback