dataset_nvl function - Exportizer Documentation

Category:

Database related

General

Returns a substitution value if the field value is null.

Syntax

dataset_nvl(
  StepNo Integer,
  FieldName String,
  SubstVal <FieldType> 
): <FieldType>

dataset_nvl(
  StepNo Integer,
  FieldIndex Integer,
  SubstVal <FieldType>
): <FieldType>

Parameters

StepNo specifies the export step, in which the function must be calculated. It is used in HTML export context only; in other cases this parameter is ignored.

FieldName is the name of the field which value to check.

FieldIndex is the index (i.e. sequence number in the field mappings collection) of the field which value to check.

SubstVal is the value to return if the field value is null. The type of SubstVal must match the type of the field.

Return value

Type: <FieldType> (depends on the database field type). Returns SubstVal, when value of the field is null, and the field value in another case.

Examples of using

dataset_nvl(1, 'Salary', 0)