我把edit1的值按查询条件combobox1内的条件查询怎么不行啊,错误为:Invalid field name---Invalid column name str1'.'.。
procedure TForm1.Button1Click(Sender: TObject);
var
str1,str2:string;
begin
str1:=combobox1.text;
str2:=edit1.text;
with query1 do
begin
close;
SQL.Clear;
SQL.Add('select * from tongxunlu where str1='''+str2+'''' );
ExecSQL;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
str1,str2:string;
begin
str1:=combobox1.text;
str2:=edit1.text;
with query1 do
begin
close;
SQL.Clear;
SQL.Add('select * from tongxunlu where str1='''+str2+'''' );
ExecSQL;
end;
end;
var
str1,str2:string;
begin
str1:=combobox1.text;
str2:=edit1.text;
with query1 do
begin
close;
SQL.Clear;
SQL.Add('select * from tongxunlu where '''+str1+'''='''+str2+'''' );
Open;
end;
end;
把str1和str2 一样写 str1 没有把变量值传递过来
-----------------------------------怎么一样写阿