Query2.Close;
Query2.ParamByName('A').AsString :=ComboBox1.Text;
Query2.ParamByName('B').AsString :=Edit1.Text;
Query2.Prepare;
Query2.Open;其中SQL内容如下:
select count(:A) as QTY
FROM table
where :A=:B运行时提示,找不到B参数是怎么回事?
多谢!
Query2.ParamByName('A').AsString :=ComboBox1.Text;
Query2.ParamByName('B').AsString :=Edit1.Text;
Query2.Prepare;
Query2.Open;其中SQL内容如下:
select count(:A) as QTY
FROM table
where :A=:B运行时提示,找不到B参数是怎么回事?
多谢!
Query2.ParamByName('A').Value :=ComboBox1.Text;
Query2.ParamByName('B').Value :=Edit1.Text;
Query2.Prepare;
Query2.Open;