Y yt_lh Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #1 如何在Delphi中写sql语句在Access数据库中表中添加Float类型的字段
M myanwei Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #2 SQL.ADD('INSERT INTO TABLENAME (FIELD) VALUES ('+FLOATTOSTR(FloatVar)+')');
R realLearning Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #6 create table test ( SINGLEFloatField SINGLE, DoubleDoubleField Double )
W wem888 Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #7 alter table tablename add fieldname typecode length go
任 任豆豆 Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #8 with adoquery1 do begin close; sql.text := 'INSERT INTO TALBE1(FIELD1) VALUSEMY1)'; Parameters.ParamByName('MY1').Value := FloatVar; EXECSQL; end;
with adoquery1 do begin close; sql.text := 'INSERT INTO TALBE1(FIELD1) VALUSEMY1)'; Parameters.ParamByName('MY1').Value := FloatVar; EXECSQL; end;
M mazhixin888 Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-17 #9 你的字段应设为小数,数值范围设为非零,再设一下小数位数再用以上各位大侠的方法即可 如还有问题可以交流qq:65354045