Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How-To populate SELECT LIST default value from SQL Query

489178Mar 10 2006 — edited Mar 10 2006
OK, I've done my homework, and did not find my answer in the Forum, so here it is.

I have a Page that displays fields from a SQL Query. The Page also has below that radiogroups, checkboxes, and Select Lists to allow the user to change values in the fields that are displayed at the top of the Region. I am able to pre-populate the radiogroups and checkboxes by performing a SELECT in the 'Source value or expression' of the Source area of the Page Item.

However, I am unable to do the same for the Select List fields. Their default value ends up being the first value in the LOV ('-- None --' for NULL values). Source Used: Only when current value in session state is null. Source Type: SQL Query. Also, when I first go into the Page when running it, and check the Session State values, they are all null, so I don't understand why the field is not populated by the SQL Query statement as the radiogroups and checkboxes are.

Any suggestions??? I've tried all sorts of combinations.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2006
Added on Mar 10 2006
4 comments
1,011 views