OraFAQ Forum: Forms » Run query as form

Home » Developer & Programmer » Forms » Run query as form - user prompt

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

Run query as form - user prompt [message #163409]

Thu, 16 March 2006 11:14

sephina
Messages: 14
Registered: March 2006

Junior Member

Hi. I am trying to use a query to run as a form that asks the user for a value before producing the results. Does anybody know how to do this?

Thanks!

Sephina

Report message to a moderator

Re: Run query as form - user prompt [message #163413 is a reply to message #163409]

Thu, 16 March 2006 11:54

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hi

Create a parameter in a form
and in the query write some thing like this

select * from emp where emp_id=:PARAMETER_NAME;

but in forms you need to hold your result in some fields or variables.
when you run the .fmx it will ask for parameter value enter it you will see the results.

Let us know how it Works

Regards
Faiz

Report message to a moderator

Re: Run query as form - user prompt [message #163571 is a reply to message #163413]

Fri, 17 March 2006 05:25

sephina
Messages: 14
Registered: March 2006

Junior Member

Hi. Thanks for your help..I was just wondering if there was any online resources that could help us out with the coding. We're struggling to make it work!!

Thanks
Sephina

Report message to a moderator