OraFAQ Forum: Forms » Search Form like LOV

Home » Developer & Programmer » Forms » Search Form like LOV (Form 6i, Windows 7)

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

Search Form like LOV [message #683207]

Tue, 15 December 2020 04:04

hissam78
Messages: 141
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,

Report message to a moderator

Re: Search Form like LOV [message #683217 is a reply to message #683207]

Tue, 15 December 2020 15:15

Littlefoot
Messages: 21667
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;

Report message to a moderator

Re: Search Form like LOV [message #683223 is a reply to message #683217]

Wed, 16 December 2020 06:29

hissam78
Messages: 141
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...

Report message to a moderator

Re: Search Form like LOV [message #683230 is a reply to message #683223]

Thu, 17 December 2020 05:20

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

Senior Member
Account Moderator

You're welcome.

Report message to a moderator

Previous Topic:	format problem
Next Topic:	LOCK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 22 15:20:17 CDT 2021