I am using Quickbooks Enterprise Version 8. I need to have updated data, hourly, from the SalesOrderLine table. I don't need any data from other tables. When I connect to the table, multiple tables are automatically refreshed. How can I limit the refresh to this one table?

Thanks

Pete

The QODBC Optimizer has to read other tables to determine whether rows within the SaleOrderLine need updating. Check that the "Multi-table Sync" option isn't checked.

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more.

Thanks,

It still takes 8 minutes to update the table, so I guess it won't work for us.

It would really help to know what you really want. This example will retrieve all SaleOrderLines that have been modified or created in the last 60 minutes directly from QuickBooks in seconds:

SELECT * FROM SalesOrderLine calldirect where TimeModified >= {fn TIMESTAMPADD(SQL_TSI_MINUTE, -60, {fn NOW()})}