Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count command problem?
Message
 
 
To
11/03/2009 14:54:36
Barbara Hill
B.L. Hill Applications Limited
Halifax, Nova Scotia, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Miscellaneous
Thread ID:
01387221
Message ID:
01387224
Views:
73
Corrupted index maybe?

>OK , call me stupid but can anyone explain this.
>
>I was asked to find the number of records in a table with a particular status. I did a count
>
>COUNT TO x FOR elecstat = "M"
>
>The result = 64085
>
>So, they wanted to look at them in a separate table so I issued the following command:
>
>COPY TO c:\temp\movedele FOR elecstat = "M"
>
>I was surprised to see there were only 63879 records copied.
>
>HUH?
>
>There are 9 records marked for deletion, there is only the one table opened, deleted is set off.
>
>What am I missing?
>
>Thanks
>
>Barb
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform