>Hi everyone,
>
>Just now I got this error message. I know why it happened, it's because I choose lot's of items in multilist, which affect on Init method one of my other controls. I think, it's VFP limitation 255 char on the macro string. So, my questions are:
>1) Will in VFP7.0 this limitation be fixed?
>2) How can I resolve this situation? Do I need to calculate length of my macro string, finding space, etc. Would be a real PITA :(
You may have run into a problem with the complexity of the WHERE clause; if so, you can alter the support for more complex queries through the SYS(3055) setting. The folowing is quoted from the VFP help file:
SYS(3055) – FOR and WHERE Clause Complexity
See Also
Sets the complexity level of the FOR and WHERE clauses in commands and functions that support those clauses.
Syntax
SYS(3055 [, nComplexity])
Returns
Character
Arguments
nComplexity
Specifies the complexity level. The valid range for nComplexity is 320 to 2040. The default value is 320. If you specify an odd value, it is rounded down to the closest even integer.
Remarks
If you receive the error 1308 - Insufficient Stack Space or 1812 - SQL: Statement Too Long, you can increase the FOR and WHEN clause complexity to help prevent the error.