>>Hello to evryone...
>>
>>Has anyone of you know how to increase the stack space limitation of visual foxpro environment.
>>
>
>No - the only time I've encountered an insufficient stack space error was with very deep recursion, and I'd expect that with any interpretive environment with a fixed maximum names space size. Your best bet is to revise deep recursions into iteration by appending recursive references onto the taoil of a list of iterative examinations.
>
>----------------->>>>>
>
>Thanx ED for your prompt reply to my queries...
>
>The nature of my program is that the user is allowed to filter records interactively by clicking the mouse right button on textbox control object. Sometime, the user wants to filter more fields/control box that cause error.
If you're buidling a long filter expresssion and it's eventually blowing for complexity, try adjusting the value of SYS(3055) - this adjusts the size and complexity values of FOR and WHERE clauses; it defaults to 320, and can be set in the range of 320-2040 (320 is a minimum and specifies the number of fields involved in an expressions, increae it by 8 for each added fiedl above some threshold - in SQL Updates, it needs to be increased whenever the number of fields involved in the update + the filtration exceeds 40 names; an increase of 8 is equivalent to adding one additional name to the maximum.) There is a performance hit as the size of the where name expression increases.