procedure TForm1.Button5Click(Sender: TObject);
var
ts1:integer;
ts2:integer;
nfen1:integer;
nfen2:integer;begin
nfen2:=adotable1.fieldbyname('zongfen').asinteger;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('select sum(feng) as nfen1 from f_leixin');
if nfen1<>nfen2 then begin
application.MessageBox('定议的总题分不等于确定的类型分,请检查','检查');
end;
end;
end.为什么执行后,总是提示“不等于确定的类型分”,一查才知道SUM求和的值nfen2与实际不符,总是431267 ,为什么啊????
var
ts1:integer;
ts2:integer;
nfen1:integer;
nfen2:integer;begin
nfen2:=adotable1.fieldbyname('zongfen').asinteger;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('select sum(feng) as nfen1 from f_leixin');
if nfen1<>nfen2 then begin
application.MessageBox('定议的总题分不等于确定的类型分,请检查','检查');
end;
end;
end.为什么执行后,总是提示“不等于确定的类型分”,一查才知道SUM求和的值nfen2与实际不符,总是431267 ,为什么啊????
nfen2:=adotable1.fieldbyname('zongfen').asinteger;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('select sum(feng) as nfen1 from f_leixin');
adoquery1.sql.open;
adoquery1.execute;
if nfen1<>nfen2 then begin
application.MessageBox('定议的总题分不等于确定的类型分,请检查','检查');
end;
end;
end.
var
ts1,ts2,nfen1,nfen2:integer;
begin
nfen2:=adotable1.fieldbyname('zongfen').asinteger; adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('select sum(feng) as nfen1 from f_leixin');
adoquery1.sql.open; nfen1 : =adoquery1.fieldbyname('nfen1').asinteger; if nfen1<>nfen2 then
application.MessageBox('定议的总题分不等于确定的类型分,请检查','检查');
end;
应该是adoquery1.fieldbyname('nfen1').asinteger<>nfen2 then
....
同意espp(浴室巨鲸) 等人说的
var
ts1,ts2,nfen1,nfen2:integer;
begin
nfen2:=adotable1.fieldbyname('zongfen').asinteger;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('select sum(feng) as nfen1 from f_leixin');
try
adoquery1.sql.open;
nfen1 : =adoquery1.fieldbyname('nfen1').asinteger;
if nfen1<>nfen2 then
application.MessageBox('定议的总题分不等于确定的类型分,请检查','检查');
except
//异常信息
end;
end;