adoquery_out.Close;
adoquery_out.SQL.Clear;
adoquery_out.SQL.Text:='select sum '+'(name_amount) from output_wastage_amount, dw_basic,OUTPUT_WASTAGE_type where left(dw_basic.dw_id, '+'len('''+pdw(gloabnode.Data)^.id+ ''')) = '''+pdw(gloabnode.Data)^.id+''' '+
'and OUTPUT_WASTAGE_type.OUT_WAST_ID = ''5'' and occur_date='''+datetostr(datime)+'''';
adoquery_out.Open;
edit_s.Text:='';
if adoquery_out.RecordCount<>0 then edit_s.Text:= adoquery_out.Fieldbyname('name_amount').AsString;
运行后出现找不到'name_amount'字段,字段是正确的把上述的sum去掉就行但是我需要的是总数,把结果放到edit中,我应该怎麽写啊
adoquery_out.SQL.Clear;
adoquery_out.SQL.Text:='select sum '+'(name_amount) from output_wastage_amount, dw_basic,OUTPUT_WASTAGE_type where left(dw_basic.dw_id, '+'len('''+pdw(gloabnode.Data)^.id+ ''')) = '''+pdw(gloabnode.Data)^.id+''' '+
'and OUTPUT_WASTAGE_type.OUT_WAST_ID = ''5'' and occur_date='''+datetostr(datime)+'''';
adoquery_out.Open;
edit_s.Text:='';
if adoquery_out.RecordCount<>0 then edit_s.Text:= adoquery_out.Fieldbyname('name_amount').AsString;
运行后出现找不到'name_amount'字段,字段是正确的把上述的sum去掉就行但是我需要的是总数,把结果放到edit中,我应该怎麽写啊
OK
adoquery_out.SQL.Clear;
adoquery_out.SQL.Text:='select sum '+'(name_amount) as name_amount from output_wastage_amount, dw_basic,OUTPUT_WASTAGE_type where left(dw_basic.dw_id, '+'len('''+pdw(gloabnode.Data)^.id+ ''')) = '''+pdw(gloabnode.Data)^.id+''' '+
'and OUTPUT_WASTAGE_type.OUT_WAST_ID = ''5'' and occur_date='''+datetostr(datime)+'''';
adoquery_out.Open;
edit_s.Text:='';
if adoquery_out.RecordCount<>0 then edit_s.Text:= adoquery_out.Fieldbyname('name_amount').AsString;