Home » Developer & Programmer » Forms » Search (Find) form like LOV (database 10g,developer 6I window xp)
Search (Find) form like LOV [message #404925] Mon, 25 May 2009 08:46 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
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
Re: Search (Find) form like LOV [message #404964 is a reply to message #404925] Mon, 25 May 2009 16:12 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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?
Re: Search (Find) form like LOV [message #404974 is a reply to message #404925] Mon, 25 May 2009 22:26 Go to previous messageGo to next message
azamkhan
Messages: 548
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...
Re: Search (Find) form like LOV [message #405028 is a reply to message #404925] Tue, 26 May 2009 02:17 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
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 159 times)
Re: Search (Find) form like LOV [message #405452 is a reply to message #404974] Wed, 27 May 2009 21:52 Go to previous messageGo to next message
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
Re: Search (Find) form like LOV [message #405476 is a reply to message #404925] Wed, 27 May 2009 23:49 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Thanks for your help


Regards


Shahzaib ismail
Previous Topic: scrollbar on tab pages
Next Topic: login form...
Goto Forum:
  


Current Time: Fri Dec 02 14:24:26 CST 2016

Total time taken to generate the page: 0.16771 seconds