Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing List Parameter
Message
De
21/06/2001 19:36:26
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
 
 
À
21/06/2001 16:38:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00522175
Message ID:
00522219
Vues:
9
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform