Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reccount()
Message
De
08/04/2002 04:43:10
 
 
À
08/04/2002 04:35:50
Philip Jones
Cornwall County Council
Truro, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00642064
Message ID:
00642067
Vues:
20
This message has been marked as the solution to the initial question of the thread.
Philip,
Why not just check for EOF()? If the table is empty or only contains deleted records, then EOF() returns .t.

>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.
Daniel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform