procedure TFrm_bargainm.DBGridEh1EditButtonClick(Sender: TObject);
begin
try
adoQuery1.disablecontrols;application.CreateForm(Tfrm_ygcx,frm_ygcx);
frm_ygcx.ShowModal;
if frm_ygcx.DBGridEh1.SelectedRows.Count > 1 then
begin
for i := 0 to frm_ygcx.DBGridEh1.SelectedRows.Count- 1 do
begin
adoquery1.append;
frm_ygcx.DBGridEh1.DataSource.DataSet.GotoBookMark(pointer(frm_ygcx.DBGridEh1.SelectedRows.Items[i]));
adoquery1.FieldByName('empNo').AsString := frm_ygcx.adoquery1.FieldByName('empNo').AsString;
adoquery1.FieldByName('empname').AsString := frm_ygcx.adoquery1.FieldByName('empname').AsString;
adoquery1.FieldByName('empsex').AsString := frm_ygcx.adoquery1.FieldByName('empsex').AsString;
adoquery1.FieldByName('deptbm').AsString := frm_ygcx.adoquery1.FieldByName('deptbm').AsString;
adoquery1.FieldByName('deptname').AsString := frm_ygcx.adoquery1.FieldByName('deptname').AsString;
adoquery1.FieldByName('emppy').AsString := frm_ygcx.adoquery1.FieldByName('py').AsString;
end;这个程序本身没问题,我想得到当TFrm_bargainm的adoquery1.FieldByName('empNo').AsString和frm_ygcx.adoquery1.FieldByName('empNo').AsString;一致时报警并退出,不用所有退出,之前没有一致的数据照样导入
begin
try
adoQuery1.disablecontrols;application.CreateForm(Tfrm_ygcx,frm_ygcx);
frm_ygcx.ShowModal;
if frm_ygcx.DBGridEh1.SelectedRows.Count > 1 then
begin
for i := 0 to frm_ygcx.DBGridEh1.SelectedRows.Count- 1 do
begin
adoquery1.append;
frm_ygcx.DBGridEh1.DataSource.DataSet.GotoBookMark(pointer(frm_ygcx.DBGridEh1.SelectedRows.Items[i]));
adoquery1.FieldByName('empNo').AsString := frm_ygcx.adoquery1.FieldByName('empNo').AsString;
adoquery1.FieldByName('empname').AsString := frm_ygcx.adoquery1.FieldByName('empname').AsString;
adoquery1.FieldByName('empsex').AsString := frm_ygcx.adoquery1.FieldByName('empsex').AsString;
adoquery1.FieldByName('deptbm').AsString := frm_ygcx.adoquery1.FieldByName('deptbm').AsString;
adoquery1.FieldByName('deptname').AsString := frm_ygcx.adoquery1.FieldByName('deptname').AsString;
adoquery1.FieldByName('emppy').AsString := frm_ygcx.adoquery1.FieldByName('py').AsString;
end;这个程序本身没问题,我想得到当TFrm_bargainm的adoquery1.FieldByName('empNo').AsString和frm_ygcx.adoquery1.FieldByName('empNo').AsString;一致时报警并退出,不用所有退出,之前没有一致的数据照样导入
begin
if adoquery1.FieldByName('empNo').AsString=frm_ygcx.adoquery1.FieldByName('empNo').AsString then continue;//若有相同的此条数据就不导入,并检查执行下一条
adoquery1.append;
frm_ygcx.DBGridEh1.DataSource.DataSet.GotoBookMark(pointer(frm_ygcx.DBGridEh1.SelectedRows.Items[i]));
adoquery1.FieldByName('empNo').AsString := frm_ygcx.adoquery1.FieldByName('empNo').AsString;
adoquery1.FieldByName('empname').AsString := frm_ygcx.adoquery1.FieldByName('empname').AsString;
adoquery1.FieldByName('empsex').AsString := frm_ygcx.adoquery1.FieldByName('empsex').AsString;
adoquery1.FieldByName('deptbm').AsString := frm_ygcx.adoquery1.FieldByName('deptbm').AsString;
adoquery1.FieldByName('deptname').AsString := frm_ygcx.adoquery1.FieldByName('deptname').AsString;
adoquery1.FieldByName('emppy').AsString := frm_ygcx.adoquery1.FieldByName('py').AsString;
end;
tool -- editor options -- color
CnPack的CnWizards 是一个IDE增强工具,挺不错的,不是你理解的那种第三方控件
如果这两个字段设置的主键,就直接用
try
ado.sql.text := 'insert into table values(你的内容);
excet
....
//跳过这一个数据
end;