Home » Developer & Programmer » Forms » LOV Button
LOV Button [message #676163] Fri, 17 May 2019 22:05 Go to next message
Messages: 3
Registered: June 2017
Junior Member
I had a text item reference no and a lov button for it.
The source columns and return columns are of the the same datatype.
The column width are the same except for one item.
The LOV button works fine but when I save the form, the LOV button is displayed again
and I need to select a value from the LOV to proceed.
As suggested in some postings, the 'Validate from List' should be changed to 'No'.
I tried that and it worked but I need to validate the value entered so that the only
valid values are entered.

Can anyone suggest me a solution? Thanks...
Re: LOV Button [message #676167 is a reply to message #676163] Sat, 18 May 2019 11:42 Go to previous message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Solution to what? Either select a valid value from a LoV (or enter it manually) if "Validate from list" is set to "Yes" so that Save works, or - if that property is set to "No" - let users save invalid values.

Alternatively, you could create a WHEN-VALIDATE-ITEM trigger which wouldn't let you save invalid values, but that's what "Validate from list" does anyway.
Previous Topic: SQL Statement Ignore
Next Topic: Copy file using oracle forms 6i
Goto Forum:

Current Time: Fri May 24 12:35:26 CDT 2024