Forum Discussion

John Murray's avatar
John Murray
Copper Contributor
Mar 30, 2018

How to order multiple database queries?

I've got a spreadsheet that has 28 different database queries via ODBC connection to a DB2 database.  Most all use the same value to limit the query results and can run in any order.  However, there are a few that are based on the results of one of the others (such as query 10 returns a key that needs to be used in query 20). 

When I do a "Refresh All" what order the queries run in I have no idea.  I know I can control what queries run when I do a "Refresh All" via the property of the query, but it's this dependency that I can't control. 

What I would like to have is let's say a group of 20 queries that run via "Refresh All" (actually I have it where they kick off when a formula value changes) and then a few that run when a dependent query completes.  Any guidance would be appreciated.

No RepliesBe the first to reply

Resources