The generic formulas provides tools to manage Invantive Control, run SQL statements on the connected databases and/or applications and retrieve information on Invantive Control for Excel.
The generic formulas are always available, independent of the connected database.
The following formulas are available:
%% Begin Waypoint %%
- [[I_END_MODE]]
- [[I_FIRST_LOG_OFF]]
- [[I_FIRST_LOG_ON]]
- [[I_FORMULA]]
- [[I_GET_NUMERIC_OR_DEFAULT]]
- [[I_INTEGRATION_ACTIVE]]
- [[I_LAST_LOG_OFF]]
- [[I_LAST_LOG_ON]]
- [[I_NUMBER_FORMAT]]
- [[I_SQL_SCALAR]]
- [[I_SQL_SELECT_SCALAR]]
- [[I_SQL_SELECT_TABLE]]
- [[I_START_MODE]]
- [[I_SYNC_ALL]]
- [[I_SYNC_DOWNLOAD]]
- [[I_SYNC_UPLOAD]]
- [[I_SYSTEM_VARIABLE]]
- [[I_TRANSLATE_KEY]]
- [[I_TRANSLATE]]
- [[I_USER_LOGON_CODE]]
- [[I_VERSION]]
%% End Waypoint %%