invantive documentation
Invantive Support ForumsLog In / Sign Up

I_SQL_SELECT_SCALAR

The Excel formula I_SQL_SELECT_SCALAR composes and executes a SQL select statement, returning the single column, single row result.

Parameters:

  • fieldName: the name of the column to select.
  • tableName: the name of the table.
  • whereClause: the where clause for the statement.
  • orderByClause: the order instructions.
  • postFix: postfix for the statement.
  • valueNoValue: value to return when no row was retrieved.
  • valueToomanyValues: value to return when more than one row was retrieved.
  • process: Excel boolean indicating whether to actually execute the statement.

Returns: the single column, single row result when made available.

Release Notes