Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recount()*2 - only lines with data
Message
De
04/08/2003 05:40:09
 
 
À
04/08/2003 05:34:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00816386
Message ID:
00816404
Vues:
17
>I get error massage (Variable EMPTY is not found) by the following command:
>
count for not empty to it
>


Chaim, you need to create an expression which will be tested for by the COUNT command. Your statement "count for not empty to it" is telling the COUNT command to look for a field called "empty" in the cursor which it cannot find. Lets say you have a field called "Surname" in yoiur cursor and you want to count the number of records where a "Surname" has been entered. Then you could use:
COUNT FOR !EMPTY( Surname ) TO nNumRecords
This would check each record for non-empty Surname fields. You can replace the "!EMPTY( Surname )" expression with any expression you want to test for including compound statements eg:
COUNT FOR !EMPTY( Surname ) .AND. !DELETED() TO nNumRecords
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform