General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>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.
In VFP 8 and earlier, 26. In VFP 9, it's based on SYS(3055).
But as Mike said, put the items in a cursor and don't worry about it.
Tamar
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