We recently purchased QODBC driver and found some difficulty summarized in question below.
We would like to receive your help/support on this matter. If there are any unclear description or situation, please let us know.

Question 1
When we execute selected sentense* to the following tables*, it only shows the last sentence although there are other records or transactions.

* Selected Sentence
SELECT * FROM JournalEntryCreditLine where TxnNumber = 5625 ;

* TABLE:
JournalEntryCreditLine
JournalEntryDebitLine

We could only obtain "FQSaveToCache" False(0)" record; however we also like to obtain "FQSaveToCache" True(1)"records.

If there are any QODBC setting or options regarding the description of selected sentence above, we would like to have your support.

Our system and registration number are as follows:

OS = Microsoft Windows XP Professional SP1
Soft = MicrosoftAccess 2003
QuickBooks = UK Pro 2003

Product Ordered: QODBC Desktop Driver for Quickbooks UK 2006 Read Only
We look forward to hear from you soon.
Best Regards

You will never find any "FQSaveToCache" True(1) records in any of the tables. We only use "FQSaveToCache" set True(1) to group multiple inserts to form a transaction as part of a sequence of inserts. The column is only there as a placeholder.

See: JournalEntry, JournalEntryCreditLine and JournalEntryDebitLine for more.