• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

specifying null when adding a button

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • specifying null when adding a button

    How do you specify a null on the button condition "Expression used To Enable Button" see screen shot.docx. As in "{STATUS} == null"
    Attached Files

  • #2
    I believe a null value would come through to the front-end as an empty string (''), so you wouldn't be able to distinguish between an empty/blank value and a null value. If your file can have both null values AND empty/blank values in that field, then I'd suggest you adjust your data source to handle nulls explicitly -- for instance, you could use coalesce to return a string value of *NULL whenever the field is set to null:

    select FREQUENCY, coalesce(STATUS,'*NULL') as STATUS from XXXX...
    Last edited by robert.swanson; 12-21-2022, 02:00 PM.

    Comment


    • #3
      after reading your response i tried '' in the condition statement and it worked...

      Comment

      Working...
      X