Forum Stats

  • 3,855,345 Users
  • 2,264,499 Discussions
  • 7,905,975 Comments

Discussions

'Select List' Application Item displays Null instead of 'Select a Value'

V Rickert
V Rickert Member Posts: 165
edited Apr 23, 2013 12:34PM in APEX Discussions
I have defined an application item as a Select List and I am trying to display "Select a Value" for a null value. I have set 'Null Display Value' to 'Select a Value' and set Display Null Values to Yes. I would like the message "Select a Value' to always display when the user is entering initial values to 'CREATE' an entry in the table. The user is not required to enter a value. I just would like to display the message anyway. How do I 'make' APEX display the message. Even though I have set values, nothing displays.

Best Answer

  • V Rickert
    V Rickert Member Posts: 165
    edited Apr 23, 2013 12:34PM Answer ✓
    OK. I've found the answer. I just needed to include IS NOT NULL in the WHERE CLAUSE of my Select Statement mapped to my Select List and the Extra Null would disappear and allow my message to display on the application page.

    Edited by: V Rickert on Apr 23, 2013 9:33 AM

Answers

  • V Rickert
    V Rickert Member Posts: 165
    edited Apr 23, 2013 12:34PM Answer ✓
    OK. I've found the answer. I just needed to include IS NOT NULL in the WHERE CLAUSE of my Select Statement mapped to my Select List and the Extra Null would disappear and allow my message to display on the application page.

    Edited by: V Rickert on Apr 23, 2013 9:33 AM
This discussion has been closed.