|
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
|
|
| isPaid universally null? QB Pro 2007, QODBC v7.00.00.214 |
| Author |
Message |
| Alan |
| |
| Group | : Members |
| Posts | : 1 |
| Joined | : 2007-05-03 |
|
| Profile |
|
| Posted : 2007-05-03 02:20:02 |
Hi --
We recently upgraded to QB Pro '07 and Qodbc v7.00.00.214.
In the invoice table, we're finding qodb returns IsPaid = NULL for every row, even on paid invoices.
To ensure this wasn't an error in our application, we confirmed this bug using the qodbc C++ demo.
This query
select * from invoiceline
run in the C++ demo window is always IsPaid is null.
Is this a known bug? Is there a fix? What might be going on?
Thanks for a great product. This is the first strangeness w/ QODBC we've encountered
Alan
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-05-03 11:24:33 |
QODBC v7.00.00.214 (and higher) will return NULLs for all fields that cannot be kept in sync by default, because of limitations within Intuit's SDK design, whenever you do a:
select * from invoiceline
If you turn on "Dirty Reads" - QODBC will return the most current value that was loaded into the optimizer cache, and there is also a "Real Time" option that uses the slower method (read as real slow) to get the data directly out of QuickBooks making sure you get the most current value for the requested fields. (Real Time is the previous method used that you are used to).
My recommended settings for using QODBC are shown here:
For an explaination of all the options available to you, see: How do I setup the QODBC Optimizer? Where are the Optimizer options? |
|
|
|
|