Forums

Find answers, ask questions, and connect with our
community all around the world.

Home Forum Ideas ifnull / coalesce function in Omnis

  • ifnull / coalesce function in Omnis

    Posted by Giacomo Manzoli on August 8, 2023 at 8:16 am
    Vote up
    Up
    4
    ::

    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 8 months, 2 weeks ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.