在DBGRID 的AFTERPOST加入下面代码:
WITH ADOQUERY1 DO
BEGIN
SQL。CLOSE;
SQL。CLEAR;
SQL。ADD(‘SELECT 编号 FROM TABLE GROUP BY 编号 HAVING COUNT(编号)>1');
open;
while recordcount>1 do
MessageBox(‘编号重复', '提示', MB_OK);
在DBGRID 的AFTERPOST加入下面代码:
WITH ADOQUERY1 DO
BEGIN
SQL。CLOSE;
SQL。CLEAR;
SQL。ADD(‘SELECT 编号 FROM TABLE GROUP BY 编号 HAVING COUNT(编号)>1');
open;
while recordcount>1 then
MessageBox(‘编号重复', '提示', MB_OK);