Home » Developer & Programmer » Forms » Search Form like LOV (Form 6i, Windows 7)
Search Form like LOV [message #683207] Tue, 15 December 2020 04:04 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear All,
Requested you to please ,
somebody can help me, how to make a query for searching Employee name from Tabular Form
e.g. "Employee Name" we enter in "Search" field and click on "button" then
specific employee detail display in the detail tabular form.


Thankful,

Regards,
Re: Search Form like LOV [message #683217 is a reply to message #683207] Tue, 15 December 2020 15:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Looks like you're reinventing the wheel. Forms does it itself:
- enter query mode
- enter some name into appropriate column
- execute query



The way you want to do it might be as follows: create a WHEN-BUTTON-PRESSED trigger as

go_block('tabular_block');
execute_query;
Create PRE-QUERY trigger on the tabular block as

:tabular_block.emp_name := :control_block.emp_name;
Re: Search Form like LOV [message #683223 is a reply to message #683217] Wed, 16 December 2020 06:29 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks a lot Little Foot, Grateful to you , it works fine, Yes this is what we need.

Bundle of Thanks...
Re: Search Form like LOV [message #683230 is a reply to message #683223] Thu, 17 December 2020 05:20 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome.
Previous Topic: format problem
Next Topic: LOCK
Goto Forum:
  


Current Time: Thu Mar 28 17:18:09 CDT 2024