Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing List Parameter
Message
From
21/06/2001 19:36:26
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
21/06/2001 16:38:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00522175
Message ID:
00522219
Views:
8
Hi Edgar,

How about:
cParList = "('A','B','C','D')"

DO MyProg WITH cParList

PROCEDURE MyProg

LPARAMETERS pcParList

SELECT * ;
    FROM mytable ;
    WHERE myfield ;
    IN &pcParList ;
    INTO CURSOR mycursor
Hope this helps,
Gavin...

>I got stuck with probably simple stuff, but this is the deal:
>I want to pass a parameter to my WHERE IN clause.
>What is passed will be a series of string like ‘A’,’B’,’C’,’D’
>or it could be ‘A’,’D’ (don't know how many are passed)
>So It will go like this
>
>DO myProg WITH cParList
>
>How do I do this?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform