Not able to query on TimeCreated or TimeModified |
Author |
Message |
Neal |
|
Group | : Members |
Posts | : 27 |
Joined | : 2006-07-23 |
|
Profile |
|
Posted : 2006-07-23 06:48:34 |
I am attempting to create a query to retreive records based on when they were last modified. My current statement will not return any data. I have tried reducing and increase the date range, that did not help. Please advise.
I am using the online version of Quickbooks.
Statements tried: select * from InvoiceLine OPTIMIZED WHERE TimeModified > {ts '2006-07-01 00:00:00.001'} select * from InvoiceLine UNOPTIMIZED WHERE TimeModified > {ts '2006-07-01 00:00:00.001'}
This should return approx 200 records.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-23 12:28:16 |
This appears to be another bug in QODBC v6.00.00.176. Don't use the UNOPTIMIZED tag for now. The other tags appear to be working ok in my testing.
IMPORTANT: Further testing showed that these issues only happen with the QuickBooks Online Edition and SDK 3.0 versions of QuickBooks (non-USA editions of QuickBooks). The above SQL statements work correctly with USA editions of QuickBooks 2006. |
|
|
|
Neal |
|
Group | : Members |
Posts | : 27 |
Joined | : 2006-07-23 |
|
Profile |
|
Posted : 2006-07-23 13:37:28 |
Tom, Thanks for the quick reply. Please let me know when a patch or work around is avaible.
Neal |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-23 16:24:37 |
Will do. Use the standard format for now:
select * from InvoiceLine WHERE TimeModified > {ts '2006-07-01 00:00:00.001'} |
|
|
|
Neal |
|
Group | : Members |
Posts | : 27 |
Joined | : 2006-07-23 |
|
Profile |
|
Posted : 2006-07-23 22:23:03 |
That does not work either. I get the same Null responce as with the other statements.
On the same note. This appears to be restricted to the invoice releated tables and the ReceivePayment tables. I ran the TimeModified filter on other tables with success.
I have modified my code to filter the date after retreiving, but I'm taking a preformance hit due to the downloads. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-24 08:25:11 |
You should also resync your ReceivePayment table as prior revisions to QODBC v6.00.00.176 had missing lines.
sp_optimizefullsync ReceivePayment |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-03 10:01:35 |
This issue was resolved with the release of QODBC v7.00.00.194 (and later). |
|
|
|