Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select with IN clause is giving an error
Message
From
18/09/2006 08:18:31
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154265
Message ID:
01154620
Views:
10
PMFJI,
<snip>
>>The maximum number of options for INLIST() is 25. I think it is the same for SQL IN(). You might also try
>>WHERE (mtgid IN (first 25) OR mtgid IN (second 25) etc)
>
>That should work, too.

but in my help for vfp6, it says the maximum number is 24 and it starts with the 2nd expression. I have always taken that to mean that you can have 23 values to check against, and 1 value as the one being checked.

Beth
Previous
Reply
Map
View

Click here to load this message in the networking platform