>Bret
>
>Thanks for the reply
>
>I'm after an IN clause that may contain 2,5 or 'x' items. Because a dbc view cannot manage a variable number of parameters I need to load the list of values into a parameter. In the past I've seen this done using a special technique to "fool" the view into inserting the parameter into the SQL and having it interpreted as a list... but I can't remember what it is!
>
>Regards
>
>JR
Your right I tried this on my database. You just cant seem to get a view to accept a parameter for an IN clause. There must be some translation that is happening behind the scenes. When I come across something like this I end up developing my own SQL query on the fly in a method call of program code. Then I construct the statement myself. You should be able to do this depending on your data source. If I find a different solution using a view I will post it.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope