Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the max number of items in IN clause?
Message
From
27/04/2010 11:33:15
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01462166
Message ID:
01462216
Views:
59
>>>If you add one more, there would be an error.
>>
>>Use a table then there is virtually no limit.
>
>It was not my question of possible workarounds. I just wanted a confirmation of this particular limit.

May I ask why you replied as you did? It is obvious what you wanted. It is obvious you did not request workarounds. Therefore no reply was necessary from you.

When I am presented with a silly limit, I find a way to work around the limit and then I drop the limited methodology from my practice.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform