2,498
社区成员
发帖
与我相关
我的任务
分享
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from qq');
adoquery1.open;
adoquery1.append;
adoquery1.fieldbyname('月份').asstring:=yuefen;
adoquery1.fieldbyname('时间').asstring:=riqi;
adoquery1.fieldbyname('姓名').asstring:=combobox2.Text;
adoquery1.fieldbyname('服务项目').asstring:=edit2.Text;
adoquery1.fieldbyname('金额').asstring:=edit3.Text;
adoquery1.post;
riqi:=formatdatetime('dddddd',now);
要得到时间不是这样的吧。riqi:=formatdatetime('yyyy-mm-dd',now);
adoquery1.append;
.......
adoquery1.post;
riqi:=Quotedstr(formatdatetime('yyyy-mm-dd',now));
yuefen:=Quotedstr(formatdatetime('mm',now));
with adoquery1 do
begin
close;
sql.text:='insert into qq(月份,时间,姓名,服务项目,金额) values ('
+yuefen+','+riqi+','+Quotedstr(combobox2.Text)+','
+Quotedstr(edit2.Text)+','+Quotedstr(edit3.Text)+')';
ExecSQL;
end;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into qq(月份,时间,姓名,服务项目,金额) values (');
ADOQUERY1.SQL.Add(quotedstr(yuefen)+',');
ADOQUERY1.SQL.Add(quotedstr(riqi)+',');
ADOQUERY1.SQL.Add(quotedstr(combobox2.Text)+',');
ADOQUERY1.SQL.Add(quotedstr(edit2.Text)+',');
ADOQUERY1.SQL.Add(edit3.Text+')');
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into qq(月份,时间,姓名,服务项目,金额) values (');
ADOQUERY1.SQL.Add(yuefen+',');
ADOQUERY1.SQL.Add(quotedstr(riqi)+',');
ADOQUERY1.SQL.Add(quotedstr(combobox2.Tex)t+',');
ADOQUERY1.SQL.Add(quotedstr(edit2.Text)+',');
ADOQUERY1.SQL.Add(edit3.Text+')');
adoquery1.ExecSQL;