Home » Developer & Programmer » Forms » compare value with recod group query (6i 10g)
compare value with recod group query [message #683297] Sat, 26 December 2020 06:17 Go to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
i have a LOV name pw which has values.
record group Name: PW
static values 
0.25
0.50
0.75
1.00
1.25
1.50
1.75
2.00
when i input value in field then validated the inserted value with the values stored in record group. please advised

Re: compare value with recod group query [message #683302 is a reply to message #683297] Sat, 26 December 2020 10:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LoV is attached to some item, right? Go to that item's Property Palette, navigate to "List of Values" group of properties and switch the Validate from List property to "Yes".
Re: compare value with recod group query [message #683305 is a reply to message #683302] Sat, 26 December 2020 20:50 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
i did as you say. if i enter wrong value which is not in record group query. it open the LOV. i want only it compare the input value with the record group query values . if exist it then next_item perform. otherwise stand in that column.
please advised
Re: compare value with recod group query [message #683306 is a reply to message #683305] Sun, 27 December 2020 05:26 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
if i enter wrong value which is not in record group query. it open the LOV
Exactly, that's expected behavior. If value you enter doesn't exist in LoV, Forms opens it so that you could pick one of valid values.


Quote:
i want only it compare the input value with the record group query values .
That's what it does.


Quote:
if exist it then next_item perform. otherwise stand in that column.
Yes; until you pick a valid value, you can't move out of that item.


So, from my point of view, everything works as it should.
Previous Topic: Error message after the backup process is complete
Next Topic: How to show coordinates on Google Map
Goto Forum:
  


Current Time: Thu Mar 28 08:30:37 CDT 2024