LongNvlExpression

What it is

LongNvlExpression is used specify how to treat a NULL value in a Long property (or field or variable). If the Long appears to be NULL, it will be assigned a default value or a specified value.

Code example

public ReadOnlyLongProperty LongNvlExample
{
	get 
	{ 
		return CalculatedLongProperty(() => 
			Operation.EditItem.Number.Nvl()); 
	}
}

 

Explanation of the example

The example above works as follows.

  • Line 1 defines a ReadOnlyLongProperty with the name LongNvlExample.
  • In Line 5 and 6 the content of this property is going to be calculated and assigned.
  • In line 6, the Long Operation.EditItem.Number is evaluated, by adding .Nvl.
  • If the Long appears to be NULL, then LongNvlExample will be assigned the value after Nvl between parentheses. When nothing is specified, the default value will be zero (0).