reccount()统计出错VFP 9.0+SQLSET DELE ON Select GYSKP_FBDELETE FROM GYSKP_FB&&表示全部删除brow
reccount()统计出错
VFP 9.0+SQL
SET DELE ON
Select "GYSKP_FB"
DELETE FROM "GYSKP_FB" &&表示全部删除
brow all &&此时显示,无记录.一切正常.
? RECCOUNT("GYSKP_FB") 此时的值,应该是0. 可是实际显示的,却是dele之前的记录数.
难道是set dele on 惹的事?
那如何,才能让RECCOUNT("GYSKP_FB")=0 呢?
[解决办法]
SELECT COUNT(1) FROM GYSKP_FB WHERE !DELETED()