Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: asifa haniff
  Where is asifa haniff?
 Alabama - United States
 asifa haniff
Subject: RE: array
Thread ID: 50984 Message ID: 50998 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Other
Date: Tuesday, September 07, 2004 8:16:35 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

Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA


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