Home » Developer & Programmer » Forms » Search character using wild card method using Forms Devloper (ORacle 10g)
Search character using wild card method using Forms Devloper [message #425276] Thu, 08 October 2009 06:54 Go to next message
nanumadhusudhan@gmail.com
Messages: 5
Registered: August 2009
Location: bangalore
Junior Member
Hello everyone could you please some help me in creating search form on form 10g want to need this type of form like

i have two block master/detail

Master block contain textbox & button,
here both the iteam are non-database,
when input parameter pass through textbox that Dept_name values contained Alphanumeric with wild card example: "Dev%".

when press apply button. respective matching records based on the search condition.should be displayed in detailed block.


Detail Block contain Empno,Ename,deptNo,Deptname.


please give the hints how to solve this blocking.


Best Regards,
Re: Search character using wild card method using Forms Devloper [message #425359 is a reply to message #425276] Thu, 08 October 2009 13:26 Go to previous messageGo to next message
Littlefoot
Messages: 20826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why are you reinventing the wheel? Forms' built-in querying functionality already supports wildcard searches (and many more). Omit "master" block. In "details" block, press <enter query>, enter search criteria into any item (or more), press <execute query>.

Anyway, I didn't quite understand how will you distinguish which item should contain "Dev%", as there's only one text item in "master" block? Why "deptname"? Why not "ename", for example?
Re: Search character using wild card method using Forms Devloper [message #425461 is a reply to message #425359] Fri, 09 October 2009 03:56 Go to previous messageGo to next message
nanumadhusudhan@gmail.com
Messages: 5
Registered: August 2009
Location: bangalore
Junior Member
Hello,

please find the attached forms ..

thanks

[Updated on: Fri, 09 October 2009 03:59]

Report message to a moderator

Re: Search character using wild card method using Forms Devloper [message #425474 is a reply to message #425461] Fri, 09 October 2009 04:58 Go to previous message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

Set your detail block's where clause property as
dept_name like :text_box

In when-button-pressed trigger

go_block(detail block);
clear_block;
execute_query;

Previous Topic: how to run form on web
Next Topic: How to Run a Oracle 10g Report in Forms 10g
Goto Forum:
  


Current Time: Tue Sep 27 05:56:48 CDT 2016

Total time taken to generate the page: 0.06547 seconds