5.1.0
How can we default the 'Select List' with the display value and save the Return Value in Database.
I have a column in a Interactive Grid whose value should be displayed as 'Yes' or 'No' .
When New Row is created it should default to display 'No'
Return values are Y or N , to be saved in the database
Problem I face is when I default the Value to 'No' , Data doesnot Save as my column in Varchar2(1)
Now, when I default the value to 'N' - It saves correctly , but the display on New Row is 'N' not 'No'
When A new Row is created, I want the field to be displayed as 'No' and data to be saved as 'N'
Any help please..

