a := StrToInt(VarToStr(EXCEL.WORKBOOKS[1].WORKSHEETS[1].EVALUATE('=COUNTIF($A:$A,"<>")')))
//開啟excel
try
FOR h:=2 TO REC_rows1 DO
BEGIN
i := FEXCEL.WORKBOOKS[1].WORKSHEETS[1].CELLS[h,1] ;
if a2.Active then
a2.Close;
a2.ParamByName('aaa').AsString := i;
a2.Open;
if not a.IsEmpty then
begin
aa := aa + i;
end
else
a1.Applyupdates;
end;
if aa <> '' then
MessageDlg('错误',mtWarning,[mbok],0);
....状况:table里没有值可以isnert
但会跳出MessageDlg
table里有值会跳出MessageDlg,不会insert
如何修正成↓
table里没有值的时候可以insert但""""不会""""跳出MessageDlg
table有值得时候会跳出MessageDlg,不会insert
//開啟excel
try
FOR h:=2 TO REC_rows1 DO
BEGIN
i := FEXCEL.WORKBOOKS[1].WORKSHEETS[1].CELLS[h,1] ;
if a2.Active then
a2.Close;
a2.ParamByName('aaa').AsString := i;
a2.Open;
if not a.IsEmpty then
begin
aa := aa + i;
end
else
a1.Applyupdates;
end;
if aa <> '' then
MessageDlg('错误',mtWarning,[mbok],0);
....状况:table里没有值可以isnert
但会跳出MessageDlg
table里有值会跳出MessageDlg,不会insert
如何修正成↓
table里没有值的时候可以insert但""""不会""""跳出MessageDlg
table有值得时候会跳出MessageDlg,不会insert
a := StrToInt(VarToStr(EXCEL.WORKBOOKS[1].WORKSHEETS[1].EVALUATE('=COUNTIF($A:$A,"<>")')))
//開啟excel
try
FOR h:=2 TO REC_rows1 DO
BEGIN
i := FEXCEL.WORKBOOKS[1].WORKSHEETS[1].CELLS[h,1] ;
if a2.Active then
a2.Close;
a2.ParamByName('aaa').AsString := i;
a2.Open;
if a2.RecordCount>0 then
begin
aa := aa + i;
end
else
a1.Applyupdates;
end;
if aa <> '' then
MessageDlg('错误',mtWarning,[mbok],0);
....
//開啟excel
try
FOR h:=2 TO REC_rows1 DO
BEGIN
i := FEXCEL.WORKBOOKS[1].WORKSHEETS[1].CELLS[h,1] ;
if a2.Active then
a2.Close;
a2.ParamByName('aaa').AsString := i;
a2.Open;
if not a.IsEmpty then
begin
MessageDlg('错误',mtWarning,[mbok],0);
aa := aa + i;
end
else
a1.Applyupdates;
end;
//if aa <> '' then