Problem solved (by using set item property --> validate from list to false)
I've made a form that displays (among other things obviously) the field "Title". Now, I had to link a LoV to that field, using records from another (old) table.
No problem there,
but now I got told that it should be possible to also enter a new value right into that field. So the LoV should be there as an option (I should be able to enter a value in the field, that isn't in the LoV, and it shouldn't give an error, but accept that value anyway).
I can't seem to find an option to turn off the "validation against LoV" or anything, any ideas please?
Thanks in advance!
I guess it's because the LoV is linked with the field, so I've removed the link between the LoV and the Title field and added the "Key-F9" event to my "Title" field.
In there, I've put:
DECLARE lovTitle boolean;
lovTitle := SHOW_LOV('LOV_LIUI');
IF NOT lovTitle THEN
Message('You have not selected a value.');
Yet, it doesn't do anything at all...
I've never worked with the "Key-F9" event (nor show_lov) before, so I presume I'm just doing something wrong?
Edited by: user11236545 on Apr 11, 2012 1:32 AM
Edited by: user11236545 on Apr 11, 2012 1:35 AM
Edited by: user11236545 on Apr 11, 2012 4:51 AM
You already solved your question, but for future reference.
Did you generate this Form from Designer or are you working in Forms Builder?
- If you are working in Forms Builder then you could ask the question in the Forms forum Forms
- If you are working in designer you can also set a property on the LOV.
I generated it in Designer.
I was looking for such a property on my LoV itself, but couldn't find it. I don't see it on any tab, nor on the Advanced tab, so that's why I eventually used the set_parameter command.
Thanks for the reply.
Inside Designer, there's a Form Generator preference 'Validate Item in LOV (LOVVAL) that by default is set to 'Yes'
Help for this preference says:
Use this preference to specify whether the item is validated using an LOV.
If this preference is set to Yes, the LOV will be used to validate the item.
Note that validation using an LOV:
· is only available for allowable values that do not include ranges
· is not performed when a foreign key constraint is only validated in the server
Edited by: Johnreardon on Apr 12, 2012 2:08 AM