OraFAQ Forum: Forms » compare value with recod group query

Home » Developer & Programmer » Forms » compare value with recod group query (6i 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

compare value with recod group query [message #683297]

Sat, 26 December 2020 06:17

shahzad-ul-hasan
Messages: 643
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

Report message to a moderator

Re: compare value with recod group query [message #683302 is a reply to message #683297]

Sat, 26 December 2020 10:12

Littlefoot
Messages: 21825
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".

Report message to a moderator

Re: compare value with recod group query [message #683305 is a reply to message #683302]

Sat, 26 December 2020 20:50

shahzad-ul-hasan
Messages: 643
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

Report message to a moderator

Re: compare value with recod group query [message #683306 is a reply to message #683305]

Sun, 27 December 2020 05:26

Littlefoot
Messages: 21825
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.

Report message to a moderator

Previous Topic:	Error message after the backup process is complete
Next Topic:	How to show coordinates on Google Map

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 16 13:07:54 CDT 2025