Dear Support,

We are using QODBC Driver 8.0.0.242 and QuickBooks Enterprise Edition 2008. When we query SELECT * FROM BillItemLine against Sample Company Database of QuickBooks in VBDemo then it shows all records. However in my Application it does not return all records in Recordset.

We found follow message in QODBC SDK message log file.

20080917.203157       I           1708    QBSDKProcessRequest          Application named 'FLEXquarters QODBC' starting requests (process 3164).

20080917.203158       I           1708    SpecVersion     Current version of qbXML in use: 7.0

20080917.203158       I           1708    QBSDKMsgSetHandler           QUERY: Bill

20080917.203158       I           1708    BillStorage::DoQuery    Returning no more than 00000500 objects

20080917.203158       E          1708    BillStorage::BuildItemLineRet    This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527

20080917.203158       I           1708    QBSDKMsgSetHandler           Request 1 completed successfully.

20080917.203158       I           1708    MsgSetHandler            Finished.

20080917.203158       I           1708    QBSDKProcessRequest          Application named 'FLEXquarters QODBC' finishing requests (process 3164), ret = 0..

Any idea why QODBC does not return all records in Recordset?

Thanks and Regards,

Clifford

Sounds like the QODBC optimized table your application is using isn't working correctly. Try:

SELECT * FROM BillItemLine Unoptimized

within you application.

See also: How do I setup the QODBC Optimizer? Where are the Optimizer options?