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

V Rickert

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.

V Rickert

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

V Rickert

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