Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How i know if my table have records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00033885
Message ID:
00033921
Vues:
51
>>>RECCOUNT() also counts deleted records!
>>
>>if you do not want the DELETED records than...
>>
>>count = 0
>>use mytable
>>do while !eof()
>> if !deleted()
>> count = count + 1
>> endif
>>enddo
>>
>>?count && your number of not deleted records
>
>I think DO WHILE !EOF() is a lot slower than Mr. Shevchenko's program.

Do we need in special program to do this job? Never1 Just use
COUNT to nCount FOR Not Deleted()
It's a good habit to have index tag on DELETED() to speed up many things including this one.
Another way is to use:
SET DELETED ON
COUNT to nCount
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform