Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
WHERE IN (?lcMyListOfVals) in DBC view
Message
 
À
06/11/2000 07:27:39
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00438261
Message ID:
00438269
Vues:
11
>All
>
>I know there is a way to insert a list of values into the IN() clause of a DBC View... but I can't seem to make it work.
>
>I've tried
>
>lcMyListOfVals=[val1','val2','val3]
>
>and
>
>lcMyListOfVals=[val1","val2","val3]
>
>but they don't work. I was fairly sure that the double quote version should work...
>
>Can someone please point me in the right direction?
>
>Thanks
>
>JR

The syntax is:

WHERE TableName.FieldName IN ("BOB","TOM","TED")

Is that what you are wanting?
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform