Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Max conditions in a filter
Message
De
19/06/2002 09:38:02
 
 
À
19/06/2002 09:37:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00670105
Message ID:
00670107
Vues:
23
opps. Bump either of the for/endfor by one (1) to create the error.

>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform