OraFAQ Forum: Forms » how to use when-validate-item in enter-query mode

Home » Developer & Programmer » Forms » how to use when-validate-item in enter-query mode (oracle form 10g)

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

how to use when-validate-item in enter-query mode [message #568586]

Sun, 14 October 2012 23:25

hotaka99
Messages: 3
Registered: October 2012
Location: Hanoi

Junior Member

hi, i have to create a form and i have to use trigger when-validate-item in enter-query mode
i have read trigger when-validate-item can not use Enter Query Mode
is there any way to do this when i enter-query?

Report message to a moderator

Re: how to use when-validate-item in enter-query mode [message #568597 is a reply to message #568586]

Mon, 15 October 2012 00:11

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Put the same code (you use in WHEN-VALIDATE-ITEM trigger) into the POST-QUERY (block level) trigger.

[Updated on: Mon, 15 October 2012 00:11]

Report message to a moderator

Re: how to use when-validate-item in enter-query mode [message #568611 is a reply to message #568597]

Mon, 15 October 2012 01:44

hotaka99
Messages: 3
Registered: October 2012
Location: Hanoi

Junior Member

thanks , i can do this . I put the code in to trigger KEY-NEXT-ITEM , too;

Report message to a moderator

Re: how to use when-validate-item in enter-query mode [message #568612 is a reply to message #568611]

Mon, 15 October 2012 01:52

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You can put it anywhere you want, but - why would you do that? KEY-NEXT-ITEM won't do anything smarter than WHEN-VALIDATE-ITEM so - in my opinion - KEY-NEXT-ITEM should not be used here.

Report message to a moderator

Re: how to use when-validate-item in enter-query mode [message #568615 is a reply to message #568612]

Mon, 15 October 2012 02:37

hotaka99
Messages: 3
Registered: October 2012
Location: Hanoi

Junior Member

i use KEY-NEXT-ITEM in Enter Query Mode for input the format type
eg: in column 'NAME' , i type "hotaka" then i press TAB it change to "Hotaka"

Report message to a moderator

Re: how to use when-validate-item in enter-query mode [message #568616 is a reply to message #568615]

Mon, 15 October 2012 02:44

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Now I noticed that you are saying "ENTER query mode" all the time. Sorry, I wasn't paying attention and kept thinking that it is, actually, EXECUTE query. POST-QUERY won't do anything until you execute a query (of course).

As of what you are using KEY-NEXT-ITEM for: it will do the same all the time, not only when you are querying records. Perhaps you'd rather set case-insensitive querying (i.e. so that it is irrelevant whether someone entered "hotaka", "Hotaka", "HOTAKA" or any combination of upper and lower case).

Report message to a moderator

Previous Topic:	Open froms 6i in Forms11g
Next Topic:	Changing a block not base table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 16:47:38 CDT 2024