Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recordnumber
Message
From
09/04/2001 10:11:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Recordnumber
Miscellaneous
Thread ID:
00493532
Message ID:
00493532
Views:
51
Hello,

I have a display on the form that shows the position in the table like 3/30, which means record # 3 from 30 total.
I get the 30 with COUNT function, and the 3 with RECNO().
However, when there are deleted records in the table, COUNT returns the number of not deleted records (which I like), but RECNO() returns the real position in the table, including deleted records.
So it can look like 35/30 which is weird.

What can I do to get the record number but excluding counting of deleted
records?

Thanks for your help in advance!
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform