Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recount()*2 - only lines with data
Message
From
04/08/2003 05:40:09
 
 
To
04/08/2003 05:34:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00816386
Message ID:
00816404
Views:
16
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform