Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Jefferson Aguilar
  Where is Jefferson Aguilar?
 Cabanatuan
 Philippines
 Jefferson Aguilar
 Tags
Subject: RE: RECCOUNT() - is there other way??
Thread ID: 50646 Message ID: 50663 # Views: 5 # Ratings: 0
Version: Visual FoxPro 8 Category: Other
Date: Saturday, September 04, 2004 11:15:41 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...
>
>

There are a few ways, including:
*1
SET DELETED ON
SELECT onefield FROM yourtable INTO CURSOR foo
lnReccount = _tally
*2
SET DELETED ON
COUNT TO lnReccount 

--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

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