| optinal Parameter and SQL Query [message #171384] |
Mon, 19 June 2006 07:20  |
Eclipse User |
|
|
|
Originally posted by: vincent.tiberghien.ird.sn
Hello,
I am setting up a data set with a SQL Query.
In that query, i use a parameter to select either mens or womens, like this
SELECT people
WHERE sex=?
Sex can be equal to 1(men) or 2(women).
Users will be deciding the value of this parameter. But i also would
like them to be able to choose the 'no matter' case where both mens and
womens would be selected, like this
SELECT people
there would not be any WHERE clause.
How can i do that ?
thank you
|
|
|
|
|
| Re: optinal Parameter and SQL Query [message #184584 is a reply to message #171384] |
Mon, 14 August 2006 08:21  |
| Eclipse User |
|
|
|
Originally posted by: harunhasdal.gmail.com
vincent tiberghien wrote:
> Hello,
> I am setting up a data set with a SQL Query.
> In that query, i use a parameter to select either mens or womens, like this
>
> SELECT people
> WHERE sex=?
>
> Sex can be equal to 1(men) or 2(women).
> Users will be deciding the value of this parameter. But i also would
> like them to be able to choose the 'no matter' case where both mens and
> womens would be selected, like this
>
> SELECT people
>
> there would not be any WHERE clause.
> How can i do that ?
> thank you
You can write a beforeOpen script to your dataset and modify the query
by changing queryText variable freely before execution.
|
|
|
Powered by
FUDForum. Page generated in 0.03881 seconds
Home