var dqyhname:string='p1';
begin
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from UH_user where iuser_name=:dqyhname');
Open;
end;
end这个字段在数据库里是有的怎么会查不出来的???
谢谢!!!
begin
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from UH_user where iuser_name=:dqyhname');
Open;
end;
end这个字段在数据库里是有的怎么会查不出来的???
谢谢!!!
dqyhname:string;
begin
dqyhname:='p1'
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from UH_user where iuser_name= '''+dqyhname+'''');
Open;
end;
end
Open;
定义了一个dqyhname参数,但是没有传值.
begin
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from UH_user where iuser_name=:dqyhname');
SQL.paramsbyname('dqyhname').asstring:='p1';
Open;
end;
end
dqyhname:string;
begin
dqyhname:='p1'
with adoquery1 do
begin
Close;
query.SQL.Clear;
query.SQL.Add('select * from UH_user where iuser_name=:A);
query.SQL.Parameters.ParamByName('A').Value:=dqyhname;
Open;
end;
end