应该是 with adoquery do
begin
close;
SQL.Clear;
SQL.Text:='select * from artlsbmk where zkzh=:pzkzh ';
Parameters.ParamByName('pzkzh').Value:=edit1.text;
Open;
end;
begin
close;
SQL.Clear;
SQL.Text:='select * from artlsbmk where zkzh=:pzkzh ';
Parameters.ParamByName('pzkzh').Value:=edit1.text;
Open;
end;
该不是delphi的原因吧?
begin
close;
SQL.Clear;
SQL.Text:='select * from artlsbmk where zkzh='+#39+edit1.text+#39;
Open;
with adoquery do
begin
close;
SQL.Text:='select * from artlsbmk where zkzh:=pzkzh ';
Parameters.ParamByName('pzkzh').Value:=edit1.text;
prepared;
Open;
where 语句之后的‘:=’应为‘=:’
一个dbgrid连接这个datasourse,以便来显示结果
但是却怎么也显示不出数据?这是如何回事?
无论在open后加上:active:=true还是在open前加上:active:=true还是没有用
大哥再想想是什么原因
dbgrid不能显示adoquery查询的数据,这颗怎么办?
这里有很多Delphi的连接~~我也忘了是从那里下载的了~
只好你自己去找了~不好意思~~
我要下了~886~~
with adoquery do
begin
close;
SQL.Clear;
SQL.Text:='select * from artlsbmk where zkzh=:pzkzh ';
Parameters.ParamByName('pzkzh').Value:=edit1.text;
Open;
end;
begin
close;
SQL.Clear;
SQL.Text:='select * from artlsbmk where zkzh=:pzkzh ';
Parameters.ParamByName('pzkzh').Value=:edit1.text;
ExecSql; //不用OPEN;
end;
你看这样行了吗?
begin
close;
SQL.Text:='select * from artlsbmk where zkzh:=pzkzh ';
Parameters.ParamByName('pzkzh').asstring:=edit1.text;
prepared;
Open;