Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to supply list of values to be a view parameter?
Message
De
19/03/2005 05:14:37
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
00997340
Message ID:
00997556
Vues:
11
>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)
>

Strange, One would expect &?vp_list to work
First, ?vp_list evaluates to (say) 'A4D','A4C'
Then, the macro expansion comes in

Also, see thread#812113

>But I don't want to use macro. If I switch to SQL Server, how should I make the same select command to work?


Sorry, cannot help you there. I haven't used SQL server




>>>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()
>>
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform