query3.Close;
query3.SQL.Clear;
query3.SQL.Add('insert into lishi');
query3.SQL.Add('(id,text)');
query3.SQL.Add('values(:pid,ptext)');
query3.ParamByName('pid').AsString:=inttostr(icount);
query3.ParamByName('ptext').AsString:='无描述';
query3.ExecSQL;提示:insert 语句出错,麻烦邦个忙!谢谢!
query3.SQL.Clear;
query3.SQL.Add('insert into lishi');
query3.SQL.Add('(id,text)');
query3.SQL.Add('values(:pid,ptext)');
query3.ParamByName('pid').AsString:=inttostr(icount);
query3.ParamByName('ptext').AsString:='无描述';
query3.ExecSQL;提示:insert 语句出错,麻烦邦个忙!谢谢!
query3.SQL.Clear;
query3.SQL.Add('insert into lishi');
query3.SQL.Add('(id,text)');
query3.SQL.Add('values(:pid,:ptext)');//少了个:
query3.ParamByName('pid').AsString:=inttostr(icount);
query3.ParamByName('ptext').AsString:='无描述';
query3.ExecSQL;
是不是少一个冒号?
query3.Close;
query3.SQL.Clear;
query3.SQL.Add('insert into lishi');
query3.SQL.Add('(id,text)');
query3.SQL.Add('values(:pid,:ptext)');
query3.ParamByName('pid').AsString:=inttostr(icount);
query3.ParamByName('ptext').AsString:='无描述';
query3.ExecSQL;