adoquery2.SQL.Clear;
adoquery2.SQL.Add('insert into jhk (wn,rq,zz,hh) ') ;
tj:=adoquery1.FieldValues['wn'];
adoquery2.SQL.Add(' values('''+tj+''',');
adoquery2.SQL.Add('{'+datetostr(datetimepicker1.date)+'}');
tj:=adoquery1.FieldValues['zz'];
cwstr:=adoquery1.FieldValues['hh'];
adoquery2.SQL.Add(','+tj+','+cwstr+')');
adoquery2.ExecSQL;
跟踪adoquery2.sql.text为:insert into jhk(wn,rq,zz,hh)
values('f0',{2002-05-01},174,155)
结果插入的日期用dbgrid显示成了1899-12-30,不知道为什么?
adoquery2.SQL.Add('insert into jhk (wn,rq,zz,hh) ') ;
tj:=adoquery1.FieldValues['wn'];
adoquery2.SQL.Add(' values('''+tj+''',');
adoquery2.SQL.Add('{'+datetostr(datetimepicker1.date)+'}');
tj:=adoquery1.FieldValues['zz'];
cwstr:=adoquery1.FieldValues['hh'];
adoquery2.SQL.Add(','+tj+','+cwstr+')');
adoquery2.ExecSQL;
跟踪adoquery2.sql.text为:insert into jhk(wn,rq,zz,hh)
values('f0',{2002-05-01},174,155)
结果插入的日期用dbgrid显示成了1899-12-30,不知道为什么?
values('f0','2002-05-01',174,155)sqlserver 是这样,insert into jhk(wn,rq,zz,hh)
values('f0',date'2002-05-01',174,155)
oracle是这样foxpro就不太清楚了
忘了,拜托不要在这里foxpro
这个问题是和日期格式有关系,应该按照月日年的顺序,以-隔开即可通过.不过还是谢谢你们的持续增长