Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Reccount() counts the deleted items
Hi everyone,
It just occured to me that when I use the reccount() function or an SQL count function it counts the deleted entries (the ones with their "squares" black) and I don't want those included in my totals.
Do I have to write a separate function or is there an existing command (something like SET DELETES OFF) that I can use in order to count ONLY the entries that are not deleted?
And if I have to write a function, what kind of conditions have to be included in it?
Thanks a lot in advance, Steph.
Suivant
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