Then dynamically create the test string as you need it to be... I was just suggesting a way to get it to work.
>Wayne, this will "hard code" the office strings into the Remote View.
>I would like to populate the parameter dynamically.
>Looks like VFP Parser does to process parameters in IN Clause.
>
>
>
>>How about trying...
>>
>>Test = "'191','193'"
>>
>>"Select * from Table1 where office IN("+Test+")"
>>
>>
>>
>>>Hi. I am trying to use a parameter in a IN clause with SQL Server backend. The returned cursor is always empty. I tried to populate the^parameter with :
>>>
>>>Test = '191','193'
>>>Test = "'191','193'"
>>>Test = ("'191','193'")
>>>
>>>Nothing is working.
>>>
>>>There is the SQL
>>>
>>>"Select * from Table1 where office IN (?Test)"
>>>
>>>Any idea ?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown