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.

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.

Tom, Thanks for the quick reply. Please let me know when a patch or work around is avaible.

Neal

Will do. Use the standard format for now:

select * from InvoiceLine WHERE TimeModified > {ts '2006-07-01 00:00:00.001'}

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.

You should also resync your ReceivePayment table as prior revisions to QODBC v6.00.00.176 had missing lines.

sp_optimizefullsync ReceivePayment