delphi中如何插入日期型字段

Question

adqtemp.sql.add('insert into table1(id,edittime,name)');
adqtemp.sql.add('values('+inttostr(curid)+','+quotedstr(datetimetostr(date)+','+quotedstr(myname)+')');
adqtemp.execsql;
其中id为整型数据、edittime为日期型数据(datetime)，name(varchar);
系统为什么提示出错将截断数据

Answer 1

name长度过长edittime为smalldatetime还是datetime

Answer 2

adqtemp.sql.add('insert into table1([id],edittime,[name])');
adqtemp.sql.add('values('+inttostr(curid)+','+quotedstr(datetimetostr(date)+','+quotedstr(myname)+')');//先这样看看行不行.....

Answer 3

edittime字段设置成文本类型。

Answer 4

adqtemp.sql.add('insert into table1(id,edittime,name)');
adqtemp.sql.add('values('''+inttostr(curid)+''','''+quotedstr(datetimetostr(date)+''','''+quotedstr(myname)+''')');
adqtemp.execsql;

Answer 5

sql.add('insert into table1([id],edittime,[name])');
adqtemp.sql.add('values('+inttostr(curid)+','+quotedstr(datetimetostr(date)+','+quotedstr(myname)+')');