>>I seem to recall that Calvin said that the limit was removed in an earlier version, and now depends on the amount of RAM. However, the error message "Statement is too long" is probably shown because the whole statement is too long???
>>
>No.
>
>It is indeed a limit of 159 items in the list. The string itself is not long. Can you test it with your table?
158 is fine, 159 gives an error. I found this in help under SQL Language Improvements :
Number of arguments in an IN( ) clause - Visual FoxPro 9.0 removes the limit of 24 values in the IN (Value_Set) clause for the WHERE clause. However, the number of values remains subject to the setting of SYS(3055) - FOR and WHERE Clause Complexity. For functionality changes concerning the IN clause, see Changes in Functionality for the Current Release.