Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reccount()
Message
De
08/04/2002 04:35:50
Philip Jones
Cornwall County Council
Truro, Royaume Uni
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Reccount()
Divers
Thread ID:
00642064
Message ID:
00642064
Vues:
59
In certain circumstances I want to send the record pointer to the blank record before EOF so that blank fields can be displayed (they will not be editable) without having to add a blank record. I am doing this by using the command GO BOTTOM followed by SKIP 1. I first need to check whether the table is empty because if it is SKIP 1 will encounter EOF.
I was going to use reccount() to tell whether the table was empty or not but reccount() includes deleted records. I don't want to pack the database just to find out whether it's empty or not. Is there a simple way of detecting whether the table is empty or not?

Phil.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform