Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tracking down filter cleared message
Message
De
21/01/2009 08:52:59
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
20/01/2009 09:49:38
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01375421
Message ID:
01375850
Vues:
18
>>>>>I'm getting a "filtered cleared" message as I'm generating a report on a filtered table. Is there a way to track down what is causing this?
>>>>
>>>>
>>>>procedure one
>>>>LOCAL lcFilter
>>>>
>>>>lcFilter="0"
>>>>SET FILTER TO anyfield=lcFilter // using LOCAL variable in FILTER or SET KEY... 
>>>>do two
>>>>
>>>>procedure two
>>>>*SKIP 1 && cause "filtered cleared"
>>>>REPORT FORM anyreport && cause "filtered cleared"
>>>>
>>>>
>>>>MartinaJ
>>>
>>>Great, so you can't generate filtered reports?
>>
>>You can use REPORT FORM FileName1 | ? [ENVIRONMENT] [Scope]
>> [FOR lExpression1] [WHILE lExpression2] (provide your filter in FOR expression) or don't use local variables in FILTER condition or pre-select your data into the cursor (my favorite approach).
>
>Yeah, already selected into cursor and made that work. I'm to the point where I really hate the report writer. They wrote some cool stuff like the dynamics, but what we really could have used was some basic functionality improvements.

Use Macro Substitution to set the filter.
SET FILTER TO anyfield = &lcFilter.

The variable will go out of scope, but the contents of the variable will be lowered / elevated into the SET FILTER so it remains visible.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform