Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not counting deleted records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01223920
Message ID:
01223925
Vues:
15
>hi all,
>I want to initialise some setting in a program depending on record in a dbf file. i was thinking of
>
>use table1
>if reccount() > 0
>...
>
>the only problem is that this table could have a deleted record, very hard to use excl and pack and i want reccount() to only work with non-deleted records, is there a way to do this?
>~M

RECCOUNT() function just read the header of the DBF to see how many records that DBF has, no matter if they are deleted or not. As Naomi suggest you must COUNT the records by yourself. Just don't forget to add a TAG based on DELETED() just to make sure that everything is optimizable.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform