OraFAQ Forum: Forms » requied field in FIND_BLOCK of Query

Home » Developer & Programmer » Forms » requied field in FIND_BLOCK of Query_Find Form (ebs 11.5.10 / form 6i)

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

requied field in FIND_BLOCK of Query_Find Form [message #481664]

Fri, 05 November 2010 02:07

hgdzhuanyong
Messages: 6
Registered: November 2009
Location: China

Junior Member

Hi friends
I have developed a form of Query_Find Type.
In the QUERY_FIND Block,i've set a field as requied.
But when i push the "Find" button without input that field,there is
no hints of FRM-40202:Field must be entered. and i was lead to the
"result" block straightly.
can anybody tell me in which case will this kind of issue happens?

Thanks in advance.

Report message to a moderator

Re: requied field in FIND_BLOCK of Query_Find Form [message #481665 is a reply to message #481664]

Fri, 05 November 2010 02:20

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

Senior Member
Account Moderator

You could try to modify WHEN-BUTTON-PRESSED trigger on the "find" button, such as

if :query_find.field is null then
  message('You did not enter search criteria');
  raise form_trigger_failure;
else
  go_block('result');
  execute_query;
end if;

Report message to a moderator

Re: requied field in FIND_BLOCK of Query_Find Form [message #481671 is a reply to message #481665]

Fri, 05 November 2010 03:11

hgdzhuanyong
Messages: 6
Registered: November 2009
Location: China

Junior Member

thanks,yes i can do this,
but what i want to know is why my form did not prevent me of finding while i didn't input that required field

Report message to a moderator

Re: requied field in FIND_BLOCK of Query_Find Form [message #481672 is a reply to message #481671]

Fri, 05 November 2010 03:21

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Because required is designed to ensure you enter data when inserting or updating a record to save. It only does anything if the record_status is INSERT or CHANGED.

Report message to a moderator

Re: requied field in FIND_BLOCK of Query_Find Form [message #481860 is a reply to message #481672]

Sun, 07 November 2010 19:59

hgdzhuanyong
Messages: 6
Registered: November 2009
Location: China

Junior Member

do you mean that it should have been handled manually in the first place? to aviod it from getting through

[Updated on: Sun, 07 November 2010 20:00]

Report message to a moderator

Previous Topic:	SMS via Mobile to oracle forms.
Next Topic:	how to calling reports and forms from hierarchical tree menu?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 27 02:02:36 CDT 2026