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!

Select List LOV query not able to return original value

480196Aug 22 2007 — edited Aug 23 2007
Hello,

I'm having problem with a select list LOV query.

I enter the page and my select list displays an "Extra Value" plus all the other values that I can possibly change the item to, except the value that it is already assigned in the database (so the "Extra Value" does not show up twice in the list).

I change the value in the select list to a different value.

I click "Apply Changes", but I have a validation error somewhere else on my page...so my changes have not yet been saved to the database, but my page has been submitted.

Now if I want to revert the change I made in the select list back to the original value, but I can't, because the LOV query is returning all the values that I can possibly change the item to, except the value that it is saved in the database.

How do I get around this?

Thank you,
Laura
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2007
Added on Aug 22 2007
2 comments
507 views