Added the following options to the Optimizer tab of the QODBC Setup Screen.

• Under "Keep my optimized data up to date as of:" added "The start of every new connection (with "Reload All Data" first)". This option will reload all the data in the queried table prior to requesting the data from the optimizer cache.
• Also added options: "For balances and stock quantities:" the option "Nulls" - will return NULLs for all fields that cannot be kept in sync, "Dirty Reads" - means return the most current value that was loaded into the optimizer cache, and "Real Time" which uses the slower method to get the data but making sure you get the most current value for the requested fields. (Real Time is the previous method used).
• And finally, "Optimize data after an Insert or Update" causes QODBC to do "Load Updated Data" after an insert or update in executed on a table.

Connection string values are:

• "OptimizerAllowDirtyReads" = "N|D|R" - N = NULLs, D = Dirty Reads and R = Real Time (the default if not specified)
• "OptimizerSyncAfterUpdate" = "Yes|No" (the default is No)

The following is a unofficial list of columns/fields affected by Null/Dirty Reads/Real Time as of March 27, 2007:- 

List Tables

Account

• Balance
• TotalBalance

Customer         

• Balance
• TotalBalance
• CreditCardInfoCreditCardNumber
• CreditCardInfoExpirationMonth
• CreditCardInfoExpirationYear
• CreditCardInfoNameOnCard
• CreditCardInfoCreditCardAddress
• CreditCardInfoCreditCardPostalCode

ItemInventory

• QuantityOnHand
• TotalValue
• AverageCost
• QuantityOnOrder
• QuantityOnSalesOrder    

ItemInventoryAssembly

• QuantityOnHand
• TotalValue
• AverageCost
• QuantityOnOrder
• QuantityOnSalesOrder

ItemInventoryAssemblyLine

• QuantityOnHand
• TotalValue
• AverageCost
• QuantityOnOrder
• QuantityOnSalesOrder           

Vendor

• Balance

Transaction Tables

Bill

• AmountDue
• IsPaid
• OpenAmount

BillExpenseLine

• AmountDue
• IsPaid
• OpenAmount

BillItemLine

• AmountDue
• IsPaid
• OpenAmount

CreditMemo

• CreditRemaining

CreditMemoLine

• CreditRemaining

Invoice

• AppliedAmount
• BalanceRemaining
• IsPaid

InvoiceLine

• AppliedAmount
• BalanceRemaining
• IsPaid

PurchaseOrder

• IsFullyReceived
• PurchaseOrderLineReceivedQuantity
• PurchaseOrderLineIsFullyReceived

PurchaseOrderLine

• IsFullyReceived
• PurchaseOrderLineReceivedQuantity
• PurchaseOrderLineIsFullyReceived

Sales View
[Invoice]

• Remaining
• IsPaid

[CreditReceipt]

• Remaining

SalesLine View
[Invoice]

• Remaining
• IsPaid

[CreditReceipt]

• Remaining

SalesOrder

• IsFullyInvoiced

SalesOrderLine

• IsFullyInvoiced

VendorCredit

• OpenAmount

VendorCreditExpenseLine

• OpenAmount

VendorCreditItemLine

• OpenAmount