QODBC Driver for QuickBooks Changelog

What's new in QODBC Driver for QuickBooks 6.0.0.176

• Increased internal Cache size for faster optimization and retrieval times.
• Fixed bug with max SQL length greater than 32767.
• SalesRepEntityRefFullName - size changed from 31 to 209 to match Entity full name.
• Fixed Panel Total Record count on line item tables.
• Item table now has CustomFields and most fields from all the individual item tables.
• SalesOrder and Estimates Sync using InvoiceLinkedTxn table.
• Set Pragma Cache back off/Iterator size back to 100
• Set Pragma Cache back on at 20000/Iterator size back to 500
• Added Chunk key word to help with out of memory issue.
• Added index on ListDeleted ListDelType, TimeDeleted
• Changes to database engine to fix speed issue on some multitable joins.
• JournalEntryLine table complete
• Fixed issues with Optimized SQL using IN statements not selecting records
• Fixed issue with PriceLevelPerItem updates needing ItemRef copied to the output buffer.
• Changed ReceivePayment and ReceivePaymentLine to never use iterators to avoid the SDK bug.
• Changed behaviour of Encryption Checkbox. Will open the .OPT no matter what the current setting is. Uses the encryption setting only when creating the .OPT file.
• Fixed Remaining Field value on Sales table for SalesReceipt type to correctly return 0.
• Fixed bug with blank dates in crystal.
• Incremented internal version number of cache so would force reoptimiztion of all tables on first use.
• Corrected issues with 30 - Update Error message, from setting the system clock forward and back.
• Corrected issue with not being able to clear the QODBC Messages when error 30 - Update Error message appeared.
• Added automatic COM retry logic so RETRY or SWITCH TO messages will not appear on long queries.
• Added support for NULL or empty values to be skipped in sp_report parameters section.
• Fix to sp_report summaryrowsby parameter returning 0 rows
• Addes SalesLine view.
• Fixed issues with SP_LASTINSERTID invoiceline failing to return value.
• Corrected issue that gave an XML error when inserting a new line into SalesReceiptLine.
• Corrected issue with long fields not returning all data when calling optimized data from an app like MSQRY.EXE that requests long fields in chunks.
• Issue with Optimized "Order By" being slow has been resolved.
• SP_COLUMNS stored procedure now accepts a string pattern as the table name parameter. It also accepts a table or string called "ALL". So sp_columns 'Bill%' will return all tables that start with "Bill". SP_COLUMNS will also accept a second parameter that is the pattern for the column name. So sp_columns 'Bill' 'Txn%' would return all columns in the Bill table that start with "Txn"
• SP_TABLES stored procedure now accepts a string pattern as the table name parameter, a Table Name or ALL. So sp_tables 'Bill%' will return all tables that start with "Bill"
• Fixed SalesLine table. Was only displaying one line of from each SaleReceipt and CreditMemo.
• Allowed PriceLevel header to be saved when a FixedPercent is used.
• Turned on FullName Jumpin for PriceLevel and PriceLevelPerItem
• On all subtables, deletes all records for parent ID when starting to load a new record. Example, when reloading an InvoiceLine for a given invoice all InvoiceLines with the same TxnID are removed before the invoice is loaded. This corrects leaving residule deleted lines in the optimizer table.
• SP_REPORTS. This new stored procedure works similar to SP_TABLES but lists available sp_reports.
• SP_PARAMETERS. This new stored procedure works similar to SP_COLUMNS but lists parameters available for a given SP_REPORTS. The VALUES column lists available values that can be used with the parameter.
• Fixed issue with CreditCardTxnInfoResultTxnAuthorizationStamp field not saving correctly. Driver was returning not capable when saving data to this field.