Empty table?

[FoxKid]

Is there any single command to know that the table is empty i.e. having no records
I want to use it in if command as

if <table is empty>
do something
do something
endif

Is it possible? I don't to do it like this
sele xyz
go top
if !eof()
do something
do something
endif

Thanks and Regards

 

[BPeisch]

IF RECCOUNT() = 0 should do what you want. You can pass an alias to RECCOUNT() if the table you're interested in isn't the currently selected alias.



-BP

http://www.peisch.com

 

[alvechurchdata]

RECCOUNT() will tell you the number of records. Use with care because it ignores the setting of FILTER and DELETED.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[FoxKid]

Thanks for your replies
But Sorry,
It also takes the deleted records even if I set deleted on
It will not work.

Any other idea...

Thanks and Regards

 

[BPeisch]

If you want to know the number of non-deleted records, you have to do something like:

COUNT TO nRecs

-BP

http://www.peisch.com