with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select SUM(store_num) from TABLE_STORE where pro_code='''+pro_code.Text+'''');
ExecSQL;end;
在窗体里用了DBEdit,ADOQuery和DataSourse,我想获取在pro_code=pro_code.Text的条件下的store_num的总和,为什么在DBEdit里不显示呢?
begin
Close;
SQL.Clear;
SQL.Add('select SUM(store_num) from TABLE_STORE where pro_code='''+pro_code.Text+'''');
ExecSQL;end;
在窗体里用了DBEdit,ADOQuery和DataSourse,我想获取在pro_code=pro_code.Text的条件下的store_num的总和,为什么在DBEdit里不显示呢?
begin
Close;
SQL.Clear;
SQL.Add('select SUM(store_num) from TABLE_STORE where pro_code='''+pro_code.Text+'''');
--ExecSQL;
Open;要用Open才能返回数据集
'select SUM(store_num) as 总和 from TABLE_STORE where pro_code='''+pro_code.Text+''''
然后DBEDIT的 field设置成"总和"就OK了。
'select SUM(store_num) as 总和 from TABLE_STORE where pro_code='''+pro_code.Text+''''
然后DBEDIT的 field设置成"总和"就OK了。