Why can VB Demo only display 10000 records?

Troubleshooting: The ResultSet Limitation in VB Demo

Problem Description:

When running the VB test application, only 10,000 records are returned from the table, even though there are more than 10K records in the table. Is that just a limitation to the VB Demo application, or is there a limit to the number of records the driver returns?

Solutions:

QODBC does not have a limitation of 10,000 records. The record limit is on VB Demo. VB Demo is designed to show limited records and is just an application to test your queries or connection.

We suggest trying other applications like MS Excel or MS Access; those applications can display all records from your table.

But trying to view more than 10000 records in one query is not suggested because QuickBooks has to allocate more memory for the entire result of the query in memory, and extracting too many results at one time can get the system very slow and sometimes crashes QuickBooks.

We suggest using separate queries or filtering your queries to get data blocks by date range or any other field whenever possible.