Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reccount()
Message
 
 
À
25/01/2010 15:12:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01445855
Message ID:
01445876
Vues:
43
>>>>Note that reccount() returns the total number of records - and it does so quickly. The total number of records may included deleted records, and records that don't match the current filter criteria. To get only records that you see on screen, use the COUNT command instead - or use an SQL - SELECT command.
>>>
>>>is it the same
>>>
>>>nump=count("mytable")
>>>
>>>?
>>
>>There is no COUNT function, but you can do
>>
>>set deleted on
>>select count(*) from myTable into array laCount
>>
>>lnRecords = laCount[1]
>
>can i use reecount and keep count in mind if i run into something later?

Yes, as long if it's OK to count deleted records as well.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform