Empty Table

[Marc]

Hi
Is there any property to check a table is empty

[Stefan Wuebbe]

Post by Marc
Hi
Is there any property to check a table is empty

Depends on how you define "empty table".
RecCount() does not care for deleted rows so if that matters,
you can Set Deleted On/Off and Select Count(*) From ...
If an alias is buffered, you can add an " (With Buffering=.T.) ".
See also "Count" in help.


hth
-Stefan

[Rush Strong]

Post by Marc
Hi
Is there any property to check a table is empty

As Stefan posted, a truly empty table (no records at all, deleted or
not) will have RECCOUNT() = 0. Another way to see if there are no
non-deleted records is:

GO BOTTOM
lEmpty = BOF()

- Rush