In VFP8 it works with
SELECT employee_queue_schedules.cTrans_Employees_Queues_fk FROM Employee_Queue_schedules WHERE cTrans_Employees_Queues_fk in (?&vp_list)
But I don't want to use macro. If I switch to SQL Server, how should I make the same select command to work?
>>Hi everybody,
>>
>>This command works in the Command Window:
>>
>>
SELECT employee_queue_schedules.cTrans_Employees_Queues_fk ;
>>FROM Employee_Queue_schedules ;
>>WHERE cTrans_Employees_Queues_fk in ('A4D','A4C')
>>
>>However, I don't see a way to use ('A4D','A4C') as ?vp_List
>>
>>Do you know, how can I make it?
>>
>>Thanks in advance.
>
>
>....
>WHERE cTrans_Employees_Queues_fk in (&?vp_List)
>
>vp_List = ['A4D','A4C']
>=requery()
>
If it's not broken, fix it until it is.
My Blog