Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Jefferson Aguilar
  Where is Jefferson Aguilar?
 Cabanatuan
 Philippines
 Jefferson Aguilar
 Tags
Subject: RE: RECCOUNT() - is there other way??
Thread ID: 50646 Message ID: 50665 # Views: 5 # Ratings: 0
Version: Visual FoxPro 8 Category: Other
Date: Saturday, September 04, 2004 11:20:53 AM         
   


> dear expertz........
>
> good day...
>
> Is there another way of returning the total number of records in a
> table than RECCOUNT()?
> The problem with RECCOUNT() is it also includes the records marked
> for deletion, which i dont really need.
> Is there a way (aside from looping)? Or have just i omitted a command??
>
> thanks sirs of foxpro...
> GOD bless...
>
>
> Jefferson Aguilar of Nueva Ecija Philippines
> jeffaguilar_pyc@yahoo.com
> "There is only one GOD... and He loves us all..."

select * from <MyTableWithDeletedRecord> where not deleted() into cursor cTemp
?_tally
use in select("cTemp")
select <MyTableWithDeletedRecord>


The _tally gives you the number of records in cTemp and those are the non deleted records.
reccount() reads the number of records in the table right from the header. And that number includes the records that are marked for deletion. Those are the records that are still in the table. Those are the records that can be un-deleted with "recall".


Boudewijn LutgeĀ®ink
There are 10 types of people: Those that do understand binary calculations and those that do not.

ENTIRE THREAD

RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/4/2004 8:28:56 AM
RE: RECCOUNT() - is there other way?? Posted by Eric den Doop @ 9/4/2004 11:15:41 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:18:25 AM
RE: RECCOUNT() - is there other way?? Posted by Boudewijn Lutgerink @ 9/4/2004 11:20:53 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:30:05 AM
RE: RECCOUNT() - is there other way?? Posted by Boudewijn Lutgerink @ 9/6/2004 7:12:08 AM
RE: RECCOUNT() - is there other way?? Posted by Andy Kramek @ 9/4/2004 1:24:34 PM
RE: RECCOUNT() - is there other way?? Posted by Pete Sass @ 9/4/2004 5:27:24 PM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:44:37 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:38:28 AM