Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I check for the number if recods in a table?
Message
De
04/11/1997 19:54:01
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapour
 
 
À
04/11/1997 12:24:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00058136
Message ID:
00058250
Vues:
38
>>>I want the count of the table to return empty even if it has
>>>records mark as deleted. reccount() ignores set dele on.
>>>any ideas?
>>
>>How about COUNT FOR NOT DELETED() TO lnRecCount?
>
>COUNT will move the cursor to the end of the table.
>If you don't want he cursor to move, you could use also:
>
>SELECT Count(*) FROM MyTable WHERE Deleted() = .F.

Take note that SELECT will not work for tables on table-buffering mode.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform