>What if I only want to check if the table is empty ?
If you haven't deleted records.
? RECCOUNT()
If you have deleted records
SELECT COUNT(*) AS Cnt FROM Yourtable WITH (BUFFERING = .t.) WHERE NOT DELETED() INTO Cursor crsTest
IF crsTest.Cnt = 0
MESSAGEBOX([the table is empty])
ENDIF
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst