I am using the No Sync tag in a pass-through query. I don't need the old data to be updated but am wondering if I can add the new data entries to my optimized table without it re-optimizing every entry. In a previous thread, you had said this:

Or you can resync your optimized InvoiceLine table by first doing:

sp_optimizefullsync InvoiceLine

then read directly out of the optimized table by doing:

select * from InvoiceLine NOSYNC

This is very f...a.......s.................t.

My question is this: Is the sp_optimizefullsync salesreceiptline tag what I am looking for to do what I mentioned above, and if so, how do I incorporate it into my SQL?

I tried this earlier:

sp_optimizefullsync salesreceiptLine select txnDate, salesreceiptLineQuantity, salesreceiptLineItemRefFullName from salesreceiptLine nosync WHERE Txndate >= {d '2006-09-01'}

It gives me the error:

ODBC-call failed

[QODBC] Unexpected extra token: select(#11017)

To update the salesreceiptLine table manually at any point you just run:-

sp_optimizeupdatesync salesreceiptLine

or if you want to do it on the fly within a query you do:-

select txnDate, salesreceiptLineQuantity, salesreceiptLineItemRefFullName from salesreceiptLine VERIFY WHERE Txndate >= {d '2006-09-01'}

Yes, stored procedures need to run through as seperate queries.

sp_optimizeupdatesync salesreceiptLine

will compare the timestamp of the optimized table and the live QuickBooks table and update the optimized table.

sp_optimizeupdatesync Customer

but the query needs to be run as a pass-through query as per: How do I create a Pass-Through Report using Microsoft Access 2003?