sql-update 更新数据的问题!
lyq 2001-11-27 04:02:15 下面代码为实现更新pmtempview中hb字段为pmjs*djzl/ymzzl*100 带条件where ...
但结果不对,请哪位大侠帮忙指正!
query2.Close;
query2.sql.clear;
query2.sql.add('update pmtempview set hb=:hb where pmbh=:pmbh and cd<>''A'' and cd<>''B'' and cd<>''C'' and cd<>''D''');
query2.Parameters.ParamByName('hb').value:=(pmtemp.fieldbyname('pmjs').asfloat)*(pmtemp.fieldbyname('djzl').asfloat)*100/ymzzl;
query2.Parameters.ParamByName('pmbh').value:=pm.fieldbyname('bh').value;
query2.ExecSQL;