用程序检查确保数据正确
Bookgood.rar
(2.64 KB)
有一张标准表,用来检查现有数据表的正确性,谢谢各位高手。请用VFP6.0[ 本帖最后由 tjdeming 于 2013-5-18 18:17 编辑 ]
CLOSE TABLES USE BKGD ALIAS BKGD USE 标准表 ALIAS BZB SELECT BZB SCAN *方法一 SELECT BKGD SCAN DELETED FOR ALLTRIM(BKGD.职名)==ALLTRIM(BZB.职名) AND (编号!=BZB.编号 OR ALLTRIM(类别)!=ALLTRIM(BZB.类别)) ENDSCAN *方法二 *DELETED FROM BKGD ALLTRIM(BKGD.职名)==ALLTRIM(BZB.职名) AND (编号!=BZB.编号 OR ALLTRIM(类别)!=ALLTRIM(BZB.类别)) ENDSCAN SELECT BKGD BROWSE