Note: This version will detect the Structure of the Optimizer (companyfilename.OPT) has changed and will automatically delete and recreate correctly. QODBC will them perform as it does with a fresh optimizer table. It is recommended that the user run the "Reload All Data" on the optimizer tab of QODBC Setup.

The Table modifiers used in SQL statements (tags used following the table name) to override QODBC Optimizer configuration screen settings have been enhanced:

VERIFIED | VERIFY - Forces Full Resync with QuickBooks on the optimized table before Query starts
CALLDIRECT | UNOPTIMIZED - Passthru query directly to QuickBooks - use no optimizations
OPTIMIZE | OPTIMIZED | NOSYNC - Passthru query to optimized table directly for maximum speed

Examples:

select * from customer UNOPTIMIZED
select * from customer OPTIMIZED
select * from customer VERIFIED

Made speed improvements in retrieving PriceLevelPerItem records.

Adjusted logic for Optimizer to use the ReceivePayments instead of Transaction.  Also it only synchronizes when a field requiring synchronizing is requested like the IsPaid field.

Corrected logic when security check only was performed and so it won't update the LastUpdate field.

Fixed issue with inserting into any record when the Field name included ListID or TxnID has been fixed.

Removed links from ParentRefListID to the ListID of the same table.

Removed duplicate fields in Preference for Canadian version. They were causing issues in optimizing the table.

Set Macro fields to run the table unoptimized when macro fields are used in the WHERE statement.

Corrected issues with using TxnID/ListID as the first field in an insert to append a line.

New stored procedure, sp_lastinsertidreturn on|off. Used to turn on or off the saving of sp_lastinsert values. When off it can help with performance if you do not need to call sp_lastinsert.