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 17:02:49
 
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:
00679793
Vues:
18
It would seem there should be some work around for this. If you discover anything I would be interested in seeing how you made it work.

Thanks
John


>Thanks John for your reply - yes I have tried that (although slightly different as I did not put the single quotes around number) and it works when I select into a cursor but not in a view...
>ie.
>
>strRange = "15,16,17"
>select * from events where ev_primary in (&strRange) into cursor curTemp
>
>but when I try to pass strRange to a view I either just get the first record returned or an error
>Thanks again
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform