数据库SQL问题,很菜,大虾们请帮忙
我有一个VFP6 的dbf表
tbXXX (rq n(8,0),kpj n(14,2),spj n(14,2))
我从一个文件中读出一组数据到纪录rRead:rcRead
rcRead=record
rq:longint;
kpj:longint;
spj:longint;
end;
然后附值给另一纪录 rPut:rcDDD
rcDDD=record
rq:longint;
kpj:single;
spj:single;
rput.rq:=rRead.rq;
rPut.kpj:=rRead.kpj/1000;
rPut.spj:=rRead.spj/1000;
然后我再用sql写入数据库
query1.close;
query1.sql.add('insert into tbxxx (rq,kpj,spj) ');
query1.sql.add('values ("+rPut.rq+","+rPut.kpj+","+rPut.spj+")');
query1.prepare;
query1.execsql;
query1.unprepare;
执行是出错,Data type mismath
为何?
我要如何附值?
如果我定义rcDDD.rq:tDatetime;
tbxxx表结构改为 rq d,
又如何附值?
谢谢大虾们