carlo
|
Posted: 09/05/2003, 3:12 AM |
|
I'm Using MySQL....
I create a new Grid, I select "Data Source Type = SQL" and then I write the
SQL string into "Data Source", the question is this: How can I write a
parameter into that string.
Ex.:
SELECT * FROM tbluser WHERE nome=PARAMETER
How Could I write "PARAMETER" so that it is consider as a parameter?????
Tanks a lot
|
|
|
RonB
|
Posted: 09/05/2003, 4:21 PM |
|
in the query use the {} to define parameters:
select bla from blabla where number_field={parameter_name}
or
Select bla from blabla where text_field='parameter_name}'
In the parameters box click on the + sign and under variable type parameter_name and select the source under "source"
That's it
Ron
|
|
|
|