ODBC Parameters

[OAKEJ]

I'm trying to create a report from an ODBC data source and am having problems.

Query
Select Region,Site,Repair
from Expenses
where Region IN(?)

When I try to use a multi-value parameter I get this message

Cannot add Multi-Value Query Parameter '?' for Data Set 'Expenses' because it's not supported by the data extension. I've tried to look up how to correct it but to no avail. Any Suggestions. Thanks

 

[foxdev]

I'm guessing you're trying to pass parameters like 'NE', 'SE', 'MW', etc. Correct?

I don't think I have the solution to this specific question, but is it practical for you, in this instance, to fully-form the query and send it to the server with the parameters as literals already included, as in:

select Region, Site, Repair
from Expenses
where Region IN ('NE', 'SE', 'MW')


--------------

http://www.liquidsql.com

SQLS metasearch