我想实现sql查询语句,然后查询出来的结果赋值到edit1里面,怎么做啊
!!下面是我的语句:
adoquery1.Close;
adoquery1.Parameters.ParamByName('time1').Value:=datetimepicker1.Date ;
datetimepicker2.Time :=strtotime('23:59:59');
adoquery1.Parameters.ParamByName('time2').Value :=datetimepicker2.Date;
adoquery1.SQL.Clear;
adoquery1.SQL.Text :='select sum(danjia*rksl) from ruku where rkrq >=:time1 and rkrq =<:time2';
adoquery1.Active:=true;
拜托阿!千万不要笑兄弟!
!!下面是我的语句:
adoquery1.Close;
adoquery1.Parameters.ParamByName('time1').Value:=datetimepicker1.Date ;
datetimepicker2.Time :=strtotime('23:59:59');
adoquery1.Parameters.ParamByName('time2').Value :=datetimepicker2.Date;
adoquery1.SQL.Clear;
adoquery1.SQL.Text :='select sum(danjia*rksl) from ruku where rkrq >=:time1 and rkrq =<:time2';
adoquery1.Active:=true;
拜托阿!千万不要笑兄弟!
..
edit1.text:=adoquery1.fieldbyname('ss').asstring;
错误定在以下的语句上edit1.Text :=adoquery1.fieldbyname('a').AsString ;
adoquery1.Close;
adoquery1.Parameters.ParamByName('time1').Value:=datetimepicker1.Date ;
datetimepicker2.Time :=strtotime('23:59:59');
adoquery1.Parameters.ParamByName('time2').Value :=datetimepicker2.Date;
adoquery1.SQL.Clear;
adoquery1.SQL.Text :='select sum(danjia*rksl) as ss from ruku where rkrq >=:time1 and rkrq =<:time2';
adoquery1.Active:=true;
-------
edit1.text:=adoquery1.fieldbyname('ss').asstring;
ss 不需要另外定義,你語句寫成這樣就行了
adoquery1.SQL.Text :='select sum(danjia*rksl) from ruku where rkrq >=:time1 and rkrq =<:time2';
adoquery1.Parameters.ParamByName('time1').Value:=datetimepicker1.Date ;
datetimepicker2.Time :=strtotime('23:59:59');
adoquery1.Parameters.ParamByName('time2').Value :=datetimepicker2.Date;
adoquery1.Active:=true;
这样试试
在报错就把错误贴出来
adoquery1.SQL.Clear;
adoquery1.SQL.Text :='select sum(danjia*rksl) as temp from ruku where rkrq >=:time1 and rkrq =<:time2';
adoquery1.Parameters.ParamByName('time1').Value:=FormatDateTime('yyyy-mm-dd',datetimepicker1.Date);
adoquery1.Parameters.ParamByName('time2').Value :=FormatDateTime('yyyy-mm-dd',datetimepicker2.Date);
adoquery1.Active:=true;edit1.text:=adoquery1.fieldbyname('ss').value;//取值
edit1.text:=adoquery1.fieldbyname('ss').value;//取值
改为edit1.text:=adoquery1.fieldbyname('ss').asstring;//取值谢谢了1!!