Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recno()
Message
De
04/09/2000 07:50:25
 
 
À
03/09/2000 23:27:12
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00412139
Message ID:
00412233
Vues:
19
>I can not imagine anyone using a recno as a key, but I guess it could be done.
>
>There are frequently reasons to know how many records are in a file and what records you are loking at. It is not a great and wonderful fearture, just imformative. The current application is just a simple mailing list for a geneology group. I want to recno() of Reccount() which is also the total count for members who have paid for a small newsletter we publish.
>

It's a particularly useless number when you have an index in effect; the physical record number is not likely to match up with the logical record number; if you have a file with 500 records, with the first record having the name 'zygote' and the last record having the name 'aardvark', and you have it indexed on name, the record named 'zygote' will appear at or near the end of the list, and 'aardvark' near the beginning, but they'll keep their physical record number. People who try doing things based on RECNO() (for example, some people try to use RECNO() as the basis for alternating background line color in a grid) are usually pretty miffed at the result, since there's no guarentee that an even numbered record will be bounded by two odd record numbers. If you ave a filter in effect, so that only 10 of the 500 records are valid for processing/viewing, the RECNO() values stay the same. If you delete records, the record numbers stay the same - until you pack the file and remove dead records, and all records get renumbered.

>So yes it is not a vital number, just interesting.
>
>I have much to learn with regards to VFP and I do appreciate the help!
>
>THANKS
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform