大家好,我用SQL2005连接progress数据库来进行数据查询,具体的语句如下:
select * from OpenQuery(Mfg,'select A1.JobNum,A1.ShipQty,A1.PartNum,A1.PONum,A1.POLine,PORelNum,
A2.ShipDate
from Pub.SubShipD as A1 left join Pub.SubShipH as A2 on A1.PackNum=A2.PackNum')
我现在的问题是怎么在OpenQuery里面带参数,也就是如下
select * from OpenQuery(Mfg,'select A1.JobNum,A1.ShipQty,A1.PartNum,A1.PONum,A1.POLine,PORelNum,
A2.ShipDate
from Pub.SubShipD as A1 left join Pub.SubShipH as A2 on A1.PackNum=A2.PackNum
where PONum = @PONum')
但是会报错...
错误提示为:
链接服务器"Mfg"的 OLE DB 访问接口 "MSDASQL" 返回了消息 [email=]"[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "@PONum[/email]" (10713)"。
消息 7321，级别 16，状态 2，第 1 行
准备对链接服务器 "Mfg" 的 OLE DB 访问接口 "MSDASQL" 执行查询"select A1.JobNum,A1.ShipQty,A1.PartNum,A1.PONum,A1.POLine,PORelNum,
A2.ShipDate
from Pub.SubShipD as A1 left join Pub.SubShipH as A2 on A1.PackNum=A2.PackNum
where PONum = @PONum"时出错。
请问各位高手怎样在OpenQuery中带参数呢?????????