Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
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