>I have never been able to. I think I even tried to hack the view by putting an ampersand after the question mark. All to no avail.

That's what I thought. I tried the ampersand idea too but I think the view takes the macro's value and stuffs it in the dbc right when it's created...grrrrrr...
ooooh well I'll come up with another plan.
Now where's that wish-list for VFP10? hehehe


>>employee_id field is Integer...
>>
>>This works:
>>
>>SELECT * from audits WHERE employee_id in (12,35)
>>
>>
>>This doesn't:
>>
>>lcEmployeeString = '12,35'
>>
>>SELECT *;
>> FROM audits Audits;
>> WHERE ALLTRIM(STR(Audits.employee_id)) IN (?lcEmployeeString)
>>
>>
>>I also tried this:
>>lcEmployeeString = "'12','35'"
>>lcEmployeeString = '12,35'
>>lcEmployeeString = "('12','35')"
>>
>>Can I even do this in a remote view?
>>
>>Thanks!