OraFAQ Forum: Forms » Search character using wild card method using Forms Devloper

Home » Developer & Programmer » Forms » Search character using wild card method using Forms Devloper (ORacle 10g)

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

Search character using wild card method using Forms Devloper [message #425276]

Thu, 08 October 2009 06:54

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,

Report message to a moderator

Re: Search character using wild card method using Forms Devloper [message #425359 is a reply to message #425276]

Thu, 08 October 2009 13:26

Littlefoot
Messages: 21818
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?

Report message to a moderator

Re: Search character using wild card method using Forms Devloper [message #425461 is a reply to message #425359]

Fri, 09 October 2009 03:56

nanumadhusudhan@gmail.com
Messages: 5
Registered: August 2009
Location: bangalore

Junior Member

Hello,

please find the attached forms ..

thanks

Attachment: 1search_using wildcard.JPG
(Size: 42.40KB, Downloaded 588 times)

[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

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;

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:24:27 CDT 2024