Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reccount()
Message
From
08/04/2002 04:43:10
 
 
To
08/04/2002 04:35:50
Philip Jones
Cornwall County Council
Truro, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00642064
Message ID:
00642067
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform