unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls, Buttons;type
TForm1 = class(TForm)
BitBtn1: TBitBtn;
Edit1: TEdit;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
procedure BitBtn1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.BitBtn1Click(Sender: TObject);
var xname:string;
begin
with ADOQuery1 do
parameters.ParamByName('XName')value:=Edit1.text;
close;
sql.clear;
sql.add('insert into mytxl(xm),valuse(:XName)');
Post;
open;
end;end.
注MYTXL是表名;XM是列名,请问错在哪里??应如何更改?初学者请详细!
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls, Buttons;type
TForm1 = class(TForm)
BitBtn1: TBitBtn;
Edit1: TEdit;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
procedure BitBtn1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.BitBtn1Click(Sender: TObject);
var xname:string;
begin
with ADOQuery1 do
parameters.ParamByName('XName')value:=Edit1.text;
close;
sql.clear;
sql.add('insert into mytxl(xm),valuse(:XName)');
Post;
open;
end;end.
注MYTXL是表名;XM是列名,请问错在哪里??应如何更改?初学者请详细!
解决方案 »
- 求一个多线程简单的例子
- fastreport 两个问题一起来,在线等,简单的
- 使用TIdHttp.post时,从post开始到response返回,Form没有响应...如何解决?
- 11111
- 关于《她说了一句有分量的话,我该不该继续争取呢?》帖子的最后说明。
- 菜鸟问题,table中如何用游标指向的行对变量赋值
- datetime型的數據為什麼不能和nil或'' 比較呢???
- 一个关于BDE别名的超难问题(不是高手不要进来)!(一共给150分)
- 如何使windows对一个运行应用程序监视
- 请问如何调用页面设置并将其结果留待Tprintdialog.execute中使用。
- 求助!!!
- 如何设置IdFTP1.Socket.SocksInfo.Host值
close;
sql.clear;
sql.add('insert into mytxl(xm) valuse(:XName)');
parameters.ParamByName('XName').value:=Edit1.text;
ExecSQL;
end; 从with到end 错误N多
close;
sql.clear;
sql.add('insert into mytxl(xm) valuse(:XName)');
//改成:sql.add('insert into mytxl(xm) values(:XName)'); parameters.ParamByName('XName').value:=Edit1.text;
ExecSQL;
end;
open一般在sql语句为查询语句(即只select)后用。
execsql在用SQL语句实现插入、修改、删除则在写完SQL语句后用。希望你尽快熟悉delphi,所以就多解释了一些。
close;
sql.clear;
sql.add('insert into mytxl(xm) values(:XName)');
parameters.ParamByName('XName').value:=Edit1.text;
ExecSQL;
end;