不好意思,刚才少写了一个加号 adoquery.SQL.add('select * from kehu where 编号 = ''' + edit1.text +'''');
现在把 编号 改成 combox1.text
with adoquery do begin Close ; SQL.Clear ; SQL.add('select * from kehu where 编号=:Text'); ParamByName('Text').AsString:=edit1.text; Prepare; Open ; end;
with adoQuery do begin Close; SQL.Clear; SQL.Add('select * from kehu where 编号=:Text'); Parameters.ParamByName('NO').AsString:=Edit1.Text; Prepared; Open; end;
var strsql:String ; begin adoquery.Close ; adoquery.SQL.Clear ; adoquery.SQL.add('select * from kehu where 编号=:text1'); adoquery.parambyname('text1').asstring:=edit1.text; adoquery.Open ; end这样应该没有问题!你试看看!
with adoQuery do begin Close; SQL.Clear; SQL.Add('select * from kehu where 编号=:Text'); Parameters.ParamByName('Text').Vaue:=Edit1.text; OPen; end;
标准答案: with adoQuery do begin Close; SQL.Clear; SQL.Add('select * from kehu where 编号=:Text'); Parameters.ParamByName('Text').Value:=Edit1.text; OPen; end;
adoquery.SQL.Text := 'SELECT * FROM kehu where ' + combobox1.Text + '=' + QuotedStr(text);
to steps(壮丁) 最后一次问,怎么支持模糊查询,
easy do like this adoquery.SQL.add('select * from kehu where 编号 ='+edit1.text);
你的问题好象不太明确 如果一上变量为字段名,一个变量为其值,那么 为字段串时 adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + '=' + QuotedStr(edtFieldValue.Text); 为其它类型时 adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + '=' + edtFieldValue.Text; 如果你要查询某个字段是否包含一个子串时 adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + ' LIKE ' + QuotedStr('%' + edtFieldValue.Text + '%');
adoquery.SQL.add('select * from kehu where 编号="'+edit1.text+'"');
这样行吗?
'SELECT * FROM kehu where 'combox.Text' =' + QuotedStr(text);
adoquery.SQL.add('select * from kehu where 编号 = ''' + edit1.text +'''');
begin
Close ;
SQL.Clear ;
SQL.add('select * from kehu where 编号=:Text');
ParamByName('Text').AsString:=edit1.text;
Prepare;
Open ;
end;
begin
Close;
SQL.Clear;
SQL.Add('select * from kehu where 编号=:Text');
Parameters.ParamByName('NO').AsString:=Edit1.Text;
Prepared;
Open;
end;
strsql:String ;
begin
adoquery.Close ;
adoquery.SQL.Clear ;
adoquery.SQL.add('select * from kehu where 编号=:text1');
adoquery.parambyname('text1').asstring:=edit1.text;
adoquery.Open ;
end这样应该没有问题!你试看看!
begin
Close;
SQL.Clear;
SQL.Add('select * from kehu where 编号=:Text');
Parameters.ParamByName('Text').Vaue:=Edit1.text;
OPen;
end;
with adoQuery do
begin
Close;
SQL.Clear;
SQL.Add('select * from kehu where 编号=:Text');
Parameters.ParamByName('Text').Value:=Edit1.text;
OPen;
end;
do like this
adoquery.SQL.add('select * from kehu where 编号 ='+edit1.text);
如果一上变量为字段名,一个变量为其值,那么
为字段串时
adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + '=' + QuotedStr(edtFieldValue.Text);
为其它类型时
adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + '=' + edtFieldValue.Text; 如果你要查询某个字段是否包含一个子串时
adoquery.SQL.Text := 'SELECT * FROM kehu where ' + edtFieldName.Text + ' LIKE ' + QuotedStr('%' + edtFieldValue.Text + '%');