String.Coalesce

Top  Previous  Next

 

Syntax

function String.Coalesce(val1: Variant; val2: Variant; [val3, valn: Variant; ...]): string

 

Alternative Names

ibec_Coalesce

 

Description

This takes two or more parameters and returns the first non-NULL value. Parameter values are evaluated from left to right.

 

See also

Util.IIF

 

Example

execute udsblock

as

begin

  valueout = String.Coalesce('val1', 'val2');

  GUI.ShowMessage(valueout); /* displays 'val1' */

  

  valueout = String.Coalesce(null, 'val2', 'val3', 'val4');

  GUI.ShowMessage(valueout); /* displays 'val12 */

  

  valueout = String.Coalesce(null, null, 'val3', 'val4');

  GUI.ShowMessage(valueout); /* displays 'val3' */

end