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.176 FixesSearch Forum

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

 New Topic 
 
 Post Reply 
 Release 6.0.0.176 Fixes 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-06-29 12:12:01
  • 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
  • Added 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.
 

  Top 
 New Topic 
 
 Post Reply 

Jump to