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 5.0.0.098 FixesSearch Forum

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

 New Topic 
 
 Post Reply 
 Release 5.0.0.098 Fixes 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-03-06 08:25:53
Update batches have been added. They allow you to start a batch for given table and all insert/updates will be queued until the sp_batchupdate command is issued. This allows for fewer round trips to QuickBooks which increases performance. Sp_lastinsertid has been modified to return the ListID/TxnID plus an error message column. Sp_lastinsertid returns a row for every row added to the batch. The batches are limited to a maximum of 500 transactions per batch.
  • sp_batchclear tablename – clears the current batch started with sp_batchstart.
  • sp_batchstart tablename – starts a new batch. All inserts/update issued on this table will be batched until sp_batchupdate is issued.
  • sp_batchupdate tablename – sends the batched transactions to QuickBooks. ListID/TxnIDs and error messages are available through sp_lastinsertid tablename.

A bug was fixed that prevented SalesReceiptLine table from accepting an insert to a Group Item.

IN statement fixed. If you selected ListIDs or TxnID in an IN statement if any item was not found it would not return any items. This has been corrected so that the available items will return.

QuickBooks Online Edition schema (USA only) was updated to include jumpins on most of the transaction tables.

Added an optimization to request only the max rows requested from a SELECT TOP x command that does not have a WHERE, ORDER BY or GROUP BY

Allow INSERT INTO tablename SELECT … while still maintaining old syntax of INSERT INTO tablename VALUES (SELECT …)

 

  Top 
 New Topic 
 
 Post Reply 

Jump to