Data Optimizer feature added, configured by the setup screen, with the following additional syntax: stored procedures: sp_optimizefullsync {tablename|all} sp_optimizeupdatesync {tablename|all} Table modifiers used in SQL statements (following table name) - overrides config screen settings: DOSYNC (sync data this table) NOSYNC (no sync this table) UNOPTIMIZED (passthru query - use no optimizations)
CDKey registration system added
Support for bundling in QuickBooks Enterprise Solutions 2006 Edition, simplified setup screen features in Intuit Read-Only edition.
QODBC FileDSN Setup issues
Panel Lockup issues addressed
Added ability that saves Company Name and description
GPF at end of Reload Data routine fixed
Added QuickBooks connection test button to setup screen, allowed us to remove sample data files from each QuickBooks version, making installer smaller and less confusing.
Fixed problem with Bookmark code not releasing Query. (Caused issues in Access)
Adjustments to Update logic, trying to fine tune the searches.
Added logic to support jumpin on a range of RefNumber (>, >=, <=, and <) The only issue here is that the field is listed as Alpha-Numeric but the SDK returns data based on the numeric range so if the range includes differing number of digits you might get unexpected results. Fixed InvoiceLine Increment Bug. This was done by adding a FQPrimaryKey field to all tables that had a multipart PrimaryKey. This also fixes issues with Access locating a record in InvoiceLine. Update Error Bug (Update of BillState in Customer), changed all deletes, updates and inserts to UnOptimized mode when opening.
Changed Test Connect message box to correct grammer. Corrected SQLTables call to not show the Deletable and Voidable fields. Added CUSTOM_FIELD_NAME field to sp_columns.
Added two programs so users can schedule full optimization overnight: QODBCFUL.EXE and QODBCUPD.EXE. Both set the errorlevel variable if errors are detected, and error messages are written into the log file. Passing a DSN on the command line to these programs will choose the QuickBooks company file you wish to use.
Cancelling the Reload All Data button operation was not allowing QuickBooks to close. Update of some tables that use Transaction table were slow do to a table scan. This has been fixed to use a jumpin. TimeModified jumpin no longer causes an error on the Transaction Table. |