Article ID: 166137
Article Last Modified on 3/17/2005
SELECT COUNT(*) FROM <table name> WHERE !DELETED()
COUNT TO <memvar>
CLEAR SET DELETED ON CREATE CURSOR Test ( cTest C(10)) INSERT INTO Test VALUES ( "One") INSERT INTO Test VALUES ( "Two") DELETE LOCAL aRet[1] SELECT COUNT(*) FROM Test INTO ARRAY aRet ?aRet[1] && Incorrectly returns 2 SELECT COUNT(cTest) FROM Test INTO ARRAY aRet ?aRet[1] && Incorrectly returns 2 SELECT cTest FROM Test INTO CURSOR Temp ?_TALLY && Incorrectly returns 2 SELECT COUNT(cTest) FROM Test WHERE !DELETED() INTO CURSOR Temp ?_TALLY && Correctly returns 1 COUNT TO aRet ?aRet && Correctly returns 1 CLOSE ALL
Keywords: kbprb KB166137