Functions Fields
The Functions type exposes the following members.
Fields
| Name | Description | |
|---|---|---|
 | avoidRequeryDuringEdit | during rewriting the query as a sequence of cells, avoid refreshing of power query with this flag |
| conn | connection object |
| CurrConnString | connection string can be changed for calls with different connection strings |
| dontCalcWhileClearing | avoid entering dblistfetch/dbrowfetch functions during clearing of list-fetch areas (before saving) |
| preventRefreshFlag | globally avoid refreshing of DB Functions |
| preventRefreshFlagColl | avoid refreshing of DB Functions on Workbook level (has precedence on global preventRefreshFlag) |
| queryBackupColl | for power queries the previously set query is being stored here to retrieve it back in case the new set query fails (excel doesn't allow to enter the power query editor in this case) |
| queryCache | query cache for avoiding unnecessary recalculations/data retrievals by volatile inputs to DB Functions (now(), etc.) |
| StatusCollection | global collection of information transport containers between action function and user-defined function resp. calc event procedure |