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:
01223932
Vues:
24
>>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
>
>
USE table1
>GO BOTTOM
>IF NOT BOF() AND NOT EOF()
>...
>
That actually answers the question in the message itself and not in the title! :)
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform