Posts:
12
Registered:
2/20/11
|
|
|
|
How to use parameter(s) in TOAD report manager (mySQL)
Posted:
Jun 19, 2011 6:37 PM
|
|
|
Hi Everyone,
I'm hoping someone can help me with my problem.
I'm trying to create a report using one or more parameters for the select statement in the report.
I created already a parameter, the report is prompting me for the parameter, however I can't link the parameter to the where clause in the sql statement.
What do I miss here?
Any comment much appreciated.
Thanks
dbyy
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: How to use parameter(s) in TOAD report manager (mySQL)
Posted:
Jul 6, 2011 4:43 PM
in response to: dbyy
|
|
|
Is there really no one who knows the answer to my questions?
.. or is nobody reading this forum?
Still hoping someone can answer my question.
dbyy
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: How to use parameter(s) in TOAD report manager (mySQL)
Posted:
Jul 6, 2011 5:02 PM
in response to: dbyy
|
|
|
Have the parameter in your query when you start out. For isntance:
select * from table where date = ?
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: How to use parameter(s) in TOAD report manager (mySQL)
Posted:
Jul 10, 2011 11:12 AM
in response to: Mauritz
|
|
|
well,
I know that I have to use the parameter in my query.
The question was "What is the syntax" to be used
But don't worry... I figured it out by myself.
Thanks for reading my posting
Fred
|
|
|
Posts:
1
Registered:
5/4/12
|
|
|
|
Re: How to use parameter(s) in TOAD report manager (mySQL)
Posted:
May 4, 2012 4:45 AM
in response to: dbyy
|
|
|
Hi...
can u tell me .... how to connect toad to Mysql in remote database.... i downloaded and installed, but i don't know how to connect... for this any other drivers required.....
plz help to connect....
Thanks,
velu
Message was edited by: velmurugan Natarajan
|
|
|
Posts:
1
Registered:
12/19/12
|
|
|
|
Re: How to use parameter(s) in TOAD report manager (mySQL)
Posted:
Dec 19, 2012 5:12 PM
in response to: dbyy
|
|
|
Could you please share the syntax if you figured it out? I am facing the same problem
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
