Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: asifa haniff
  Where is asifa haniff?
 Alabama - United States
 asifa haniff
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
Subject: RE: array
Thread ID: 50984 Message ID: 51097 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Other
Date: Wednesday, September 08, 2004 9:18:47 PM         

> > I am sorry if i was for not being clear. I want to use, recno() , to give me the number of records in the table. Can you please give me a syntax for it.
> The function you need is RECCOUNT() (RecNo() is just the number of the current record).
> lnAllRecs = RECCOUNT( "Your_Table_Name" )
> Note that Reccount() gives you the total number of records (,marked for deletion or not). If you just want to get the number of records that are not marked for deletion you can use:
> SELECT Your_Table_Name

> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Akron, OH, USA
Thank you so much ! that helped


array Posted by haniffa haniff @ 9/7/2004 5:39:03 PM
RE: array Posted by Yuri Rubinov @ 9/7/2004 5:47:22 PM
RE: array Posted by haniffa haniff @ 9/7/2004 5:52:35 PM
RE: array Posted by Andy Kramek @ 9/7/2004 8:16:35 PM
RE: array Posted by asifa haniff @ 9/8/2004 9:18:47 PM