| calling sql from front end [message #81980] |
Mon, 07 April 2003 02:30  |
manish mendiratta
Messages: 110
Registered: May 2002
|
Senior Member |
|
|
Hi,
I have a typical situation. I have a qry to run at end back end. I need to pass two dates for this qry. I want to pass these two dates from a form. Also i want to spool this data. pls help me as how can i pass the forms values to the qry at back end.
I can use host and run the qry but i want to pass these two dates from a form. Urgent help required.
Thanks in advance.
Manish Mendiratta
|
|
|
|
|
|
| Re: calling sql from front end [message #82013 is a reply to message #82003] |
Thu, 10 April 2003 06:06  |
manish mendiratta
Messages: 110
Registered: May 2002
|
Senior Member |
|
|
I have this qry.sql file in which in where clause i have to pass 2 dates. At the backend i can do this by passing the substitution variables. I want to run this from a form where 2 text items are given and user will pass the dates thru the items. I want that the values of dates to be passed to the substitution variables in the qry and data should be spooled.
I am using host command to run the QRY.sql.
Hope i have made my requirement clear.
Thanks
ManishM
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
