-
ifnull / coalesce function in Omnis
Hi,
I do find myself to often write/read:
Calculate <b>lVar</b> as pick(isnull(<b>lVar</b>),<b>lVar</b>,0)
to give a default value to something that can be #NULL and sometime, when the names are long, the code gets harder to read.
Having a function like the SQL ifnull(var, defaultValue) would make the code more readable and compact.
-
1 Reply
-
Hi Giacomo,
Apologies for the delayed response. Thank you for your suggestion – we agree that this is a very useful feature.
We now have new coalesce() and coalesceempty() functions, as of Studio 11.2.
Log in to reply.