query1.Close; query1.SQL.CLear; query1.SQL.Add('SELECT * FROM 表名 where 字段名=:Ass'); query1.ParamByName('Ass').AsString:=combobox1.text; query1.Open;EDIT的话,将combobox1.text改为edit1.text就行了
with ADOQuery1 do begin Close; SQL.CLear; SQL.Add('SELECT * FROM 表名 where 字段名=:p0'); ParamByName('字段名').AsString:=combobox1.text; Open; end;
应该是 dickeybird888(于伟刚) 的是对的吧,不是用字段名,是用:后面的
OVER HEHEHEHE 上面说的总是对的.
with query1 do begin close ; SQL.Text:='select * from TableName where col =:p0 '; Param[0].AsString:=ComboBox1.Text; Open; end;
query1.Close; query1.SQL.CLear; query1.SQL.Add('SELECT * FROM 表名 where 字段名='''+combobox1.text+''''); query1.Open;EDIT的话,将combobox1.text改为edit1.text.
query1.SQL.CLear;
query1.SQL.Add('SELECT * FROM 表名 where 字段名=:Ass');
query1.ParamByName('Ass').AsString:=combobox1.text;
query1.Open;EDIT的话,将combobox1.text改为edit1.text就行了
begin
Close;
SQL.CLear;
SQL.Add('SELECT * FROM 表名 where 字段名=:p0');
ParamByName('字段名').AsString:=combobox1.text;
Open;
end;
HEHEHEHE
上面说的总是对的.
begin
close ;
SQL.Text:='select * from TableName where col =:p0 ';
Param[0].AsString:=ComboBox1.Text;
Open;
end;
query1.SQL.CLear;
query1.SQL.Add('SELECT * FROM 表名 where 字段名='''+combobox1.text+'''');
query1.Open;EDIT的话,将combobox1.text改为edit1.text.
呵呵!
我也经常混!