'select * from User_charge where operator_name='+#39+Combox.text+#39 就Ok了
with adoquery1 do begin close; sql.clear; sql.add('select * from user_charge where operator_name=:a'); parameters.parameterbyname('a').value:=combobox1.text; open; end;
with adoquery1 do begin close; sql.clear; sql.add('select * from User_charge where operator_name='+quotedstr(Combox.text) );
就Ok了
begin
close;
sql.clear;
sql.add('select * from user_charge where operator_name=:a');
parameters.parameterbyname('a').value:=combobox1.text;
open;
end;
begin
close;
sql.clear;
sql.add('select * from User_charge where operator_name='+quotedstr(Combox.text)
);
open;
end;
--------------------------
xzq111()请教一下:“quotedstr”是什么意思?
--------------------------
hjp0214(风衣) 请教一下:“+#39+Combox.text+#39”是什么意思?(能详细说明一下吗?)
{ 首先呢把控件名都解释一下 }
{ ADOQ1就是ADOQuery控件 }
{ COMBox1就是ComBox控件 }
ADOQ1.SQL.TEXT:='SELECT * FROM User_Charge WHERE Operator_Name='
+ComBox1.TEXT;
ADOQ1.Open;
{ 在这里加入你其他的代码...}
ADOQ1.Close;