Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WHERE IN (?lcMyListOfVals) in DBC view
Message
From
06/11/2000 09:00:09
 
 
To
06/11/2000 07:27:39
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00438261
Message ID:
00438293
Views:
8
>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

...WHERE &?lcMyWhere

lcMyWhere = "myfield IN ('" + lcx + "', '" + lcx2 + ", ..... + ")"
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform