• Ideas

  ifnull / coalesce function in Omnis

  Posted by Giacomo Manzoli on August 8, 2023 at 8:16 am

  Vote up

  Up

  5

  ::

  Hi,

  I do find myself to often write/read:

  Calculate lVar as pick(isnull(lVar),lVar,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.

  Giacomo Manzoli replied 11 months, 1 week ago 1 Member · 0 Replies

  • General Coding
• 0 Replies

Log In to Reply