Home » Developer & Programmer » Forms » how to use when-validate-item in enter-query mode (oracle form 10g)
how to use when-validate-item in enter-query mode [message #568586] Sun, 14 October 2012 23:25 Go to next message
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?
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 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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 Go to previous messageGo to next message
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;
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 Go to previous messageGo to next message
Littlefoot
Messages: 19537
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.
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 Go to previous messageGo to next message
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"
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 Go to previous message
Littlefoot
Messages: 19537
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).

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


Current Time: Tue Sep 02 03:27:17 CDT 2014

Total time taken to generate the page: 0.08917 seconds