with dm.ADOQuery1 do begin close; sql.Clear; sql.Text:='select sum('+'chanpin_shu'+') as sr from chanpin'; open; edit1.Text:=string(FieldValues['sr']); 是计算chanpin_price的总和,那要是计算chanpin_price和chanpin_shu相乘的“积 “的合计sum(chanpin_shu*chanpin_price)
----------------------------------------------
我是菜鸟!
如下: with dm.ADOQuery1 do begin close; sql.Clear; sql.Text:='select sum(chanpin_shu) as sr from chanpin'; open; edit1.Text:=string(FieldValues['sr']);
----------------------------------------------
-和大家一起学习,一起进步!!!
这个问题我已经解决掉了sql.Text:='select sum(chanpin_shu*chanpin_price) as sr from chanpin';原来这样就行了!对了,那要计算数据库一共有多少条记录怎么写?
----------------------------------------------
我是菜鸟!
with dm.ADOQuery1 do begin close; sql.Clear; sql.Text:='select sum(chanpin_shu*chanpin_price) as cg from chanpin'; //计算总收入 open; form5.Label5.Caption:=string(FieldValues['cg']); 这个程序只是计算总收入,而我现在想要计算采购合同的总收入,而这个采购合同的字段又在另一表edit上,chanpin和edit是通过ht_num字段相关联的!帮帮我,给我提提意见!谢了 ----------------------------------------------
----------------------------------------------
我是菜鸟!