General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Unless I'm blind (which is almost true) there's no mention
>>> of IN in the VFP docs.
>
>>IN (Value_Set)
>> FieldName must contain one of the values or expressions specified in Value_Set for inclusion in the query results. When listing items in the value set, separate each item with commas.
>
>>IN (Subquery)
>> FieldName must contain one of the values returned by Subquery for inclusion in the query results.
>
>Is this from VFP9 help? In VFP8's help I don't see those 2 references.
Interesting - I can see those quotes in "SELECT - SQL Command", example 7 and 8 in my Vfp8 CHM version.
In the VFP9 help, they also occur in "Changes in Functionality for the Current Release", "Filter Conditions for Queries and Views", "SELECT - SQL Command - FROM Clause", "SELECT - SQL Command - WHERE Clause", and "SQL Language Improvements"
-Stefan
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only