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!

Simple 'Select list with submit' problem

629407Aug 25 2008 — edited Aug 26 2008
Im trying to make a column select list based on on a LOV SQL query in one of my forms. Now, I've tried making it a normal select list without the submit option and when I enter all the required data and press the create button a new entry is made in my table.

I've changed the column type to select list with submit. Now when i press the create button apex warns me that there are missing values in required columns and when I write them in the insret into my table works just fine.

Ok, now I figured that I needed a branch procedure that branches to the same form page before validation and sets my selected value from the same form page. Ive made it pass the value of the column selected. Now, when I press the create button the page redirects to itself. I've tried making another redirect process that executes on the create button, and redirects to the report page, but the same thing happens. The page is redirected to itself.

The solution should be simple enough, but it eludes me.
This post has been answered by Vidar on Aug 25 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2008
Added on Aug 25 2008
3 comments
1,101 views