Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to supply list of values to be a view parameter?
Message
From
18/03/2005 12:53:02
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00997340
Message ID:
00997345
Views:
13
Nadya

Haven't tried it (no time - busy - going home soon) but does

...WHERE cTrans_Employees_Queues_fk in (vp_list)...

not work?

Terry

>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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform