ODBC for QuickBase

Application Note for QuNect ODBC for QuickBase

Reducing Integration Reads When Keeping an on Premises Table in Sync with Quickbase

Instead of running a SELECT statement on a table to see if any records have changed or appeared since the last time you checked you can use a special SELECT statement that doesn't incur any integration reads. You can run this SELECT statement every five seconds and it will return the last modified time of each table in a Quickbase application. The result is a table like this one below. The SELECT statment looks like this:

            SELECT * from appdbid~dtm
    

or

            SELECT * FROM openquery(QUICKBASE, 'SELECT * FROM appdbid~dtm')
    

The part of the table name before the tilde must be the application identifier. You can learn how to determine the application identifier of your Quickbase application here.

You will have to store the lastRecModTime on your on premises system and compare that to the current value. If the two differ then you need to execute a SELECT statement against that table to retrieve the updated information. And you'll have to update the lastRecModTime on your on premises system with the new value.