1
 Follower
1
 Like

IsNull built-in function

Builtin & User functions
On our radar
It would be nice to have built-in function acting like SQL IsNull:
    IsNull(value, replacementValue)
    - returns value if it is not null / not default, or replacementValue if value is null / default

Currently, you have to use If like this: Value = If(Value = "", ReplacementValue, Value). In many cases Value and ReplacementValue are fields of entity/structure, which might be a field of other structure, so you know how the expression can be quite long in reality. It would be much clearer, and less chance for mistakes (like when you accidentally put something else in place of Value inside If) with IsNull function.
Created on 11 Sep 2015
Comments (1)

Hi Igor Kirtak

I make us of NullDate() construct to achieve similar need (below as example)

SyntaxEditor Code Snippet

PersonForm.Record.Person.DateOfBirth <> NullDate() and 
PersonForm.Record.Person.DateOfBirth > CurrDate()
views
346
Followers
1