adoquery.AfterScroll事件问题.
有两个adoquery:qry1,qry2
- Delphi(Pascal) code
procedure TForm14.qry1AfterScroll(DataSet: TDataSet);begin try if qry1.FieldByName('配方编号').Value<>null then begin with qry2 do begin Close; SQL.Clear; sql.Add('select ylid as 原料编号,topz as 上限,bzgl as '+ '标准,lowz as 下限,jno as 顺序 from pbf where pbbh=:a order by jno'); Parameters.ParamByName('a').Value:=Trim(qry1.FieldByName('配方编号').Value); //这里报错. open; end; end; except end; end;//报错a不存在:'qry2.parameter'a' not found',但程序还是可以断续运行的.
[解决办法]
显示参数A不存在,再检查一下qry2是否手工建立了该参数。
[解决办法]
'select ylid as 原料编号,topz as 上限,bzgl as '+
'标准,lowz as 下限,jno as 顺序 from pbf where pbbh='''+Trim(qry1.FieldByName('配方编号').Value)+''' order by jno'
不要用参数形式了,你都写成这样就算了!