Question

delphi7 ADOQuery1

var NewString:string; ClickedOK:Boolean; begin NewString:=''; ClickedOK:=InputQuery('输入框','请输入省份名称',NewString); if ClickedOK Then with ADOQuery1 do begin close; SQL.Clear; SQL.ADD('select * from qlist where sheng:=lala'); Parameters.ParamByName('lala').value:=NewString; Open; end; end; 为什么这里Parameters.ParamByName('lala').value:=NewString;报错

Answer 1

楼上指出了错误，但改错了。。 应该是：'select * from qlist where sheng=:lala'

Answer 2

'select * from qlist where sheng:=lala'，这里也有错误，应该是'select * from qlist where sheng=lala'