OraFAQ Forum: Forms » Search (Find) form like LOV

Home » Developer & Programmer » Forms » Search (Find) form like LOV (database 10g,developer 6I window xp)

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

Search (Find) form like LOV [message #404925]

Mon, 25 May 2009 08:46

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Hi all

Can any body give me any idea how can i create a form which provide me to search my entry like LOV

For example i have 2 Column

Column 1
Column 2

Now when i select Column one and write whatever i want to search

Any idea or any FMB file to give me idea

Regards

Shahzaib ISmail

Report message to a moderator

Re: Search (Find) form like LOV [message #404964 is a reply to message #404925]

Mon, 25 May 2009 16:12

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

Senior Member
Account Moderator

Looks like a basic querying scenario; enter_query, enter search criteria, execute_query.

By the way, what's wrong with Forms built-in Lists of Values?

Report message to a moderator

Re: Search (Find) form like LOV [message #404974 is a reply to message #404925]

Mon, 25 May 2009 22:26

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Or you can create 2 blocks one a non-base table block and the other one will be your base table block that holds your data.

Know on the 1st block which a non base table block you put your required items for search....

Put a search button in the block also. Now when the search button is pressed you ceate a DEFAULT_WHERE clause for the base table block according to the search block items and then you just have to issue and EXECUTE_QUERY...

Report message to a moderator

Re: Search (Find) form like LOV [message #405028 is a reply to message #404925]

Tue, 26 May 2009 02:17

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

I Think you both are not understand my requirment

please find the attachment of simple emp form

in this form i can search empno but my requirement is that i want to search sal column value which contain multiple dublicate value so how can it possible to search a no which is dublicate

Regard

Shahzaib ismail

Attachment: Emp(Find).fmb
(Size: 68.00KB, Downloaded 1035 times)

Report message to a moderator

Re: Search (Find) form like LOV [message #405452 is a reply to message #404974]

Wed, 27 May 2009 21:52

dsora
Messages: 24
Registered: May 2009

Junior Member

Ismail,
You can query base table (employees) with emp no in search field, such that you find all the emps who have same salary of empno in search field.
Once ready with the above query, in search button implement logic such that the query will be executed after clear all records in the block and set this query as block's query (pre-query trigger) and do execute-query. Now your block will show only emps who have same salary (i.e. duplicate salary).
Hope I understand correctly and given correct solution..
Smile

Report message to a moderator

Re: Search (Find) form like LOV [message #405476 is a reply to message #404925]

Wed, 27 May 2009 23:49

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Thanks for your help

Regards

Shahzaib ismail

Report message to a moderator

Previous Topic:	scrollbar on tab pages
Next Topic:	login form...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 04:07:58 CST 2025