General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only