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 09:05:35
Naomi Nosonovsky
Wisconsin, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
What is the max number of items in IN clause?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01462166
Message ID:
01462166
Views:
147
Hi everybody,

Did anyone find a maximum number of items you can use with select .. Item IN (...) clause?

The limit seems to be 159 items before it gives SQL: Statement too long (Error 1812).

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform