Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing primary keys to a View with an in filter
Message
De
17/07/2002 13:04:24
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00679658
Message ID:
00679680
Vues:
22
Have you tried it this way?
strRange = "'17','66','89'"
SELECT * FROM youthbase!ygprojects WHERE Ygprojects.pj_primary IN (&strRange)
>Hi - is it possible to use a view to return records that match the primary keys in a list?
>I have a view with this SQL
>
>SELECT *;
> FROM youthbase!ygprojects;
> WHERE Ygprojects.pj_primary IN (?vRange)
>
>
>I have tried passing it...
>strRange = "17,66,89"
>vRange = &strRange
>vRange = evaluate(strRange)
>but neither work - sometimes I get an error and sometimes I just get the first record returned
>
>If I put the values directly in the view I get the 3 records back OK
>
>Any ideas greatly appreciated
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform