Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Max conditions in a filter
Message
From
19/06/2002 09:37:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Max conditions in a filter
Miscellaneous
Thread ID:
00670105
Message ID:
00670105
Views:
55
The code below creates an error 1308: Insufficient stack space. The help says:
One of the following has occurred:
Your program is too recursive.
Your program is too complex and is nested too deeply.
An error in Visual FoxPro.

I think I got the magic number of 80 before causing the error. I did not find this number in the VFP help. I just want to confirm if this is the case.
create cursor test (f1 i, fld2 i)
insert into test values (1,2)
filterString = ''
for i =  1 to 75
	filterString = filterString + iif(empty(filterString),'',' and ') + ' f1 = ' + transform(i)
endfor
for i =  1 to 5
	filterString = filterString + iif(empty(filterString),'',' and ') + ' fld2 = ' + transform(i)
endfor
wait window transform(len(filterString))
wait window transform(occurs('AND',upper(filterString)))
set filter to &filterString
ramil
~~ learning to stand still
Next
Reply
Map
View

Click here to load this message in the networking platform