Graham Pearson
|
Posted: 06/28/2004, 6:30 PM |
|
When creating a Grid Builder, I am trying to create an SQL Statement
with IN, Is their any way to modify the Conditions select box to
include the IN so if I happen to have a list of values it would
create a query from the values.
---
Graham Pearson, System Administrator / Web Developer
Northern Indiana Educational Services Center
56535 Magnetic Drive, Mishawaka IN 46544
http://www.niesc.k12.in.us
|
|
|
Graham Pearson
|
Posted: 06/29/2004, 4:17 PM |
|
6/28/2004 8:30:10 PM
Graham Pearson <gpearson@niesc.k12.in.us> wrote in message
cbqgmq$qcc$1@news.codecharge.com
Solved this one by changing the where clause from parameter to
expression and adding in the IN (#Variable.Expression#)
> When creating a Grid Builder, I am trying to create an SQL
Statement
> with IN, Is their any way to modify the Conditions select box to
> include the IN so if I happen to have a list of values it would
> create a query from the values.
>
>
>
>
>
> ---
>
> Graham Pearson, System Administrator / Web Developer
>
> Northern Indiana Educational Services Center
>
> 56535 Magnetic Drive, Mishawaka IN 46544
>
> http://www.niesc.k12.in.us
---
Graham Pearson, System Administrator / Web Developer
Northern Indiana Educational Services Center
56535 Magnetic Drive, Mishawaka IN 46544
http://www.niesc.k12.in.us
|
|
|
|