Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Totaling Records without adding in deleted records?
Message
 
À
08/06/1999 11:29:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00227450
Message ID:
00227480
Vues:
25
If SET DELETED is ON you don't even need the FOR !DELETED() part. COUNT respects the status of SET DELETED where RECCOUNT() does not.

>How about COUNT FOR !DELETED() TO liCount?
>
>
>>Does any one know what the best way is to finding the total number of records in a table without adding in the records marked for deletion?
>>I have set deleted on.
>>The way I am currently doing it is by doing a select statment on the table and then doing a _tally command. It works but it seems like there should be a easier way.
>>
>>example: Select * from Table1 into cursor Test
>> lnTally = _tally
>>
>>Thanks,
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform