Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNT TO
Message
From
30/06/2000 10:31:32
 
 
To
30/06/2000 10:21:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00387054
Message ID:
00387064
Views:
20
>What’s wrong with the COUNT TO command?
>I wanted to count records in 2 cursors. I tried that cause I rather not to use RECCOUNT cause it counts also deleted records.
>So I tried the COUNT TO and the weirdest things happened.
>In one deleted method I count and then go to the record selected and DELETE, but it doesn’t deleted anything. So I got rid of the COUNT and went back to RECCOUNT and all was fine again.
>On the other method I COUNT and IF expression I RETURN TO MASTER, but it just terminates the whole app.
>So because of that I have to use the RECCOUNT
>Any ideas why this is happening?

Rather than doing this, you can get the count using a SQL SELECT; the _TALLY result contains the count of matching tuples, and doesn't move the record pointer in the base table.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform