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
|
|
|
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
|
|
|
|
|
|