K king_213 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-15 #1 在access数据库中如何利用adoquery清楚表中的所有数据 sql如何写???
Z zqw0117 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-15 #2 AdoQuery1.Sql.Add('Delete * from Table1'); AdoQuery1.ExecSql;
K king_213 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-15 #3 请问 如何用adoquery向access数据库中写入数据???(不用sql)
R royal1442 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-15 #4 adoquery.Insert; adoquery.fields[0].Asstring := 'ABC'; ....... adoquery.Post;
B Bauer_Zhang Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-15 #5 adoquery1.InsertRecord(); adoquery1.Append; adoquery1.AppendRecord(); adoquery1.Insert;
K king_213 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-16 #6 我用 AdoQuery1.Sql.Add('Delete * from Table1'); Adoquery.open; 程序报错!!! 我用的access数据库 请高手指点!!!
H huanghq123 Unregistered / Unconfirmed GUEST, unregistred user! 2006-02-16 #7 AdoQuery1.Sql.Add('Delete * from Table1'); Adoquery1.ExecSQL;//将open改为ExecSQL。一般在查询时用open,在delete、update时用ExecSQL
AdoQuery1.Sql.Add('Delete * from Table1'); Adoquery1.ExecSQL;//将open改为ExecSQL。一般在查询时用open,在delete、update时用ExecSQL