Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Release 6.0.0.134 FixesSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Updates and Bug Fixes

 New Topic 
 
 Post Reply 
 Release 6.0.0.134 Fixes 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-02-26 11:09:32

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.

 

  Top 
 New Topic 
 
 Post Reply 

Jump to