Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: dan delpuerto
  
 
 
 dan delpuerto
 To: Bob Ethridge
  Where is Bob Ethridge?
 Northbrook
 Illinois - United States
 Bob Ethridge
 Tags
Subject: RE: Relative Position, not recno
Thread ID: 78133 Message ID: 78966 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, October 11, 2005 4:26:08 PM         
   


this may take long time to count


rec = recno() && current record being processed
cnt = 0 && number or records from the top
go top
do while recno() != rec && or scan
cnt = cnt + 1
skip
enddo

Add .and. !eof() to be sure
add 1 if the current record is part of the count
I hope this helps

*-----

> I would like to know if there is a simple function that will tell me what position the record pointer is in, relative to the top of the table, when the table is indexed, or filtered.
>
> This is not recno(), I want a counter on my screen that shows "Record-N of _Tally" or "13 of 104" when sorted and/or filtered. This would change when I resort, or refilter based on the relative position to the top of the sorted/filtered table.
>
> Thanks,
> Bob Ethridge


ENTIRE THREAD

Relative Position, not recno Posted by Bob Ethridge @ 9/27/2005 11:17:56 PM
RE: Relative Position, not recno Posted by Barbara Peisch @ 9/28/2005 1:54:18 AM
RE: Relative Position, not recno Posted by Andy Kramek @ 9/28/2005 1:13:33 PM
RE: Relative Position, not recno Posted by dan delpuerto @ 10/11/2005 4:26:08 PM
RE: Relative Position, not recno Posted by Paul Walters @ 10/11/2005 6:53:22 PM