Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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,
another method:
Select count(*) from Table1 into array laCount
or
Select count(*) from Table1 where !deleted() into array laCount
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement