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 |