Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WHERE IN (?lcMyListOfVals) in DBC view
Message
 
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:
00438269
Views:
10
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform