想往数据库中插入一条记录,编写代码如下:
----------------------------------------------------------------------------------------------------
var
riqi,biaoti,neirong:string;
begin
riqi:=FormatDateTime('yyyy-mm-dd', Now);;
biaoti:=edit1.Text;
neirong:=memo1.Lines.Text;
adoquery1.SQL.Append('insert into riji(date,title,content) values('''+trim(riqi)+''','''+trim(biaoti)+''','''+trim(neirong)+''')');
adoquery1.Open;
-------------------------------------------------------------------------------------------------------
为什么一直插入不成功,提示“在SQL语句结尾之后找到字符”
----------------------------------------------------------------------------------------------------
var
riqi,biaoti,neirong:string;
begin
riqi:=FormatDateTime('yyyy-mm-dd', Now);;
biaoti:=edit1.Text;
neirong:=memo1.Lines.Text;
adoquery1.SQL.Append('insert into riji(date,title,content) values('''+trim(riqi)+''','''+trim(biaoti)+''','''+trim(neirong)+''')');
adoquery1.Open;
-------------------------------------------------------------------------------------------------------
为什么一直插入不成功,提示“在SQL语句结尾之后找到字符”
AdoQuery1.Close;
AdoQuery1.Clear;
adoquery1.SQL.Append('insert into riji(date,title,content) values('''+trim(riqi)+''','''+trim(biaoti)+''','''+trim(neirong)+''')');
//AdoQuery1.Open;改成
AdoQuery1.Execute;
riqi:=FormatDateTime('yyyy-mm-dd', Now);;
biaoti:=edit1.Text;
neirong:=memo1.Lines.Text;
AdoQuery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Text := 'insert into riji(date,title,content) values('''+trim(riqi)+''','''+trim(biaoti)+''','''+trim(neirong)+''')';
adoquery1.ExecSQL;---------------------------------------------------------------------------
还是提示错误。
数据库字段不能有“date",修改成"dattte",成功插入。