UniDac with Quickbooks QODBC - Enterprise
I am trying to use the QODBC driver to create a "simple" report for Positive Pay for the bank using Delphi, UniDac, and QODBC. I can connect to the QB DB, but opening the BillPaymentChecks table only returns ONE record. Presumably the top/first record. Using the exact same ODBC driver with Crystal Reports 2020 sp2.2 works fine, and returns the expected number of records and can be queried on as well. Another point is trying to return a query with the UniDac of anything other than * records will give a lexical error or operand error. Only a table open or select with no limitations will execute, but just returns the one record. I am stumped. QODBC support has been exhausted at this point. Crystal works fine, so what am i missing in UniDac causing this problem? I am using the ODBCUniProvider with the UniConnection for access.