0

length('FIELD_NAME') = 0 vs 'FIELD_NAME' = null

Hi, in the latest 3.15.2 Ninox version an important issue fixed:

"Previously, empty field values were interpreted differently on the server and client. The client recognized empty fields as "undefined," while the server stored them as "null," leading to inconsistencies in data handling. Now, both server and client correctly treat empty fields as "null" for consistency."

So far, I've been using the length() function in my database to check for empty text fields.

But when it comes to performance, should I replace it with 'FIELD_NAME' = null ?

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 days ago
    • Reported - view

    I use:

    not 'FIELD_NAME' to check if it's empty or just 'FIELD_NAME' to check if it contains something.

    eg.: if 'FIELD_NAME' then .....

      • szormpas
      • 2 days ago
      • Reported - view

        thanks. I just wanted someone to confirm it for me.

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 2 days agoLast active
  • 2Replies
  • 25Views
  • 2 Following