Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

LOV in Forms

Sabina WagmanFeb 2 2024 — edited Feb 2 2024

It's been a while since I worked with LOVs last time :) I'm working in Forms 12.2.1.4.0 and I have a very simple query in a record group. It works fine then I dont type a value in the field. Validate from list is set to Yes, but I don't want the list to appear when I type a correct value. I have tried to set it to No and do this in validate item trigger: V_LOV := SHOW_LOV('PORTAL'). But in that case I can click cancel in LOV and pass the field with an incorrect value. Not so good. Do anyone have any suggestions how to solve it?

Brgds Sabina

Comments
Post Details
Added on Feb 2 2024
2 comments
128 views