OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Query

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

Query [message #335679]

Wed, 23 July 2008 05:08

alammas
Messages: 46
Registered: July 2008

Member

Hi,
I have a data-block with EmpName and EmpCode fields, I want to fatch data into form as it is originally queried by the statement "EXECUTE_QUERY" without any select command.
Can i do this?

Report message to a moderator

Re: Query [message #335683 is a reply to message #335679]

Wed, 23 July 2008 05:12

dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai

Member

Yes It is possible.

Set where property of block to query data when using execute_query.

Report message to a moderator

Re: Query [message #335699 is a reply to message #335679]

Wed, 23 July 2008 05:42

alammas
Messages: 46
Registered: July 2008

Member

Thanx
On form a text item with name "EmpCode" recieves a code(say 50004),
And a button with name "Query" execute query gives all record for the code(50004) in query mode.

Report message to a moderator

Re: Query [message #335807 is a reply to message #335699]

Wed, 23 July 2008 16:41

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

Senior Member
Account Moderator

Is it another try of reinventing the wheel?

This is the walkthrough:
- press ENTER_QUERY button on the default Forms toolbar
- enter 50004 into the EmpCode item
- press EXECUTE_QUERY button on the default Forms toolbar

What's wrong with this, default and always working principle?

Report message to a moderator

Previous Topic:	Help in LOV
Next Topic:	How to call report in PLSQL?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 01:47:56 CDT 2025