Item Table Truncated by default CHUNK value |
Author |
Message |
|
Posted : 2007-09-28 03:21:01 |
A previous post "Entity Table Truncated by default CHUNK value " highlighted a problem. This was supposedly fixed in version QODBC v7.00.00.204 however the same problem is occuring in the item table. I am using version 7.10.00.231.
Any ideas??? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-28 09:35:51 |
Most of us use the iterator. What exactly is your problem and what version of QuickBooks are you using? |
|
|
|
|
Posted : 2007-09-28 10:18:33 |
I am using Quickbooks Version NZ 2007-2008 Premier.
I am using version QODBC version 7.10.00.231.
With the chunk size (or iterator size - tested seperately) set to 500 the QODBC driver only gets the first 500 items from the ITEM table instead of getting all the items from the ITEM table in 500 size chunks. I have temporarily set the chunk size larger to work around this. The problem occurs both in our application and the VBDEMO. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-30 09:34:53 |
This does appear to be a bug, I've reported the issue to the QODBC Software Engineer under QSupport Ticket ID:BR00000071. I will post a reply here when a fix is available for you to download. In the meantime, please continue to size the chunk value higher than the number of rows you have. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-13 11:27:36 |
This is an Intuit qbXML SDK design issue, you cannot chunk the item, entity or term tables on versions of QuickBooks that don't support iterators. This will cause the entire table to be loaded instead and could be slow if you have a lot of items. But slow and working is better than not working at all!
See: Release 8.0.0.235 Fixes |
|
|
|