BlobNvlExpression

What it is

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

Code example

public ReadOnlyBlobProperty BlobNvlExample
{
	get 
	{ 
		return CalculatedBlobProperty(() => 
			Operation.EditItem.Image.Nvl(CommonImages.OkIcon.ConvertToBlob())); 
	}
}

 

Explanation of the example

The example above works as follows.

  • Line 1 defines a ReadOnlyBlobProperty with the name BlobNvlExample.
  • In Line 5 and 6 the content of this property is going to be calculated and assigned.
  • In line 6, the Blob Operation.EditItem.Image is evaluated, by adding .Nvl.
  • If the Blob appears to be NULL, then BlobNvlExample will be assigned the value after Nvl between parentheses (CommonImages.Accept.ConvertToBlob()), which is a Blob.