ACE variables

[dodge20]

I am using Isql, but I am guessing that someone can help me out.

I am wondering if it is possible to enter more than 1 name on a single input line of an Ace Report? For example.

Enter class code: ME|WE|AR

I want to enter ME, WE, and AR for class code. In the form you can just put a pipe between them and it will query for all of them.


But my report is only pulling from the first input (ME). How do I get it to pull from all 3 codes?

 

[jpor]

The only way I am aware of, is by asking for seperate inputs
And defining 3 sepearate variables.


for example:

prompt for CC1 using "Enter 1st class code"
prompt for CC2 using "Enter 2nd class code"
prompt for CC3 using "Enter 3rd class code"

And within your select statement use:

where <tablename> in (&quot;$CC1&quot;,&quot;$CC2&quot;,&quot;$CC3&quot

and so on..

Hope this helps ?