question about counting current records. 
Author Message
 question about counting current records.

Is there an easy way to get the number of unmarked records?
RECCOUNT() relates ALL the records including those deleted.

Thanks in advance for any help.

Owen Brandon
Victoria, B.C.



Wed, 07 Mar 2001 03:00:00 GMT  
 question about counting current records.



Quote:
> Is there an easy way to get the number of unmarked records?
> RECCOUNT() relates ALL the records including those deleted.

> Thanks in advance for any help.

> Owen Brandon
> Victoria, B.C.

COUNT TO ZDELETED FOR DELETED()
with SET DELETED OFF

It helps if you created an index : INDEX ON TDEL FOR DELETED()
and SET INDEX TO TDEL

This is plain source, works in every incarnation of  Fox.
Must have an hipper, newer, way.

Regards.
Philippe



Wed, 07 Mar 2001 03:00:00 GMT  
 question about counting current records.
This requires you to have a field called TDel that mimics the deleted
behavior. It also won't be Rushmore optimizable. INDEX ON DELETED() TAG
Deleted will do it for you.

--

Craig Berntson
Microsoft Visual FoxPro MVP
Salt Lake City Fox User Group

Quote:



>> Is there an easy way to get the number of unmarked records?
>> RECCOUNT() relates ALL the records including those deleted.

>> Thanks in advance for any help.

>> Owen Brandon
>> Victoria, B.C.

>COUNT TO ZDELETED FOR DELETED()
>with SET DELETED OFF

>It helps if you created an index : INDEX ON TDEL FOR DELETED()
>and SET INDEX TO TDEL

>This is plain source, works in every incarnation of  Fox.
>Must have an hipper, newer, way.

>Regards.
>Philippe



Thu, 08 Mar 2001 03:00:00 GMT  
 question about counting current records.
One way is COUNT FOR !DELETED()

Nick

Quote:

>Is there an easy way to get the number of unmarked records?
>RECCOUNT() relates ALL the records including those deleted.

>Thanks in advance for any help.

>Owen Brandon
>Victoria, B.C.



Fri, 09 Mar 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. dbf header record - record count question

2. Status Bar - Silencing the Current Database, Record No/No of Records etc

3. Determining current screen color count

4. Any quick command to replace the current record in the current table from a record in another table?

5. record count

6. counting related records in multiple child tables

7. How to Count Selected Records w/in a SELECT

8. SQL Table record count?

9. Query counting records

10. Deleted Records show in count(*)

11. How to limit the output record count ...

12. sub total count for no duplication records.

 

 
Powered by phpBB® Forum Software