这是SQLSERVER中的存储过程:
create proc P_TEST @TxtIntoW varchar(20)
as
SELECT A.Fpass,A.FfatherOddnumber,C.IDNAME AS WEREHOUSE,
D.IDNAME AS BILL,A.Fdate,A.Fremark,
A.FwrikeMr,B.IDNo,F.FCname,
F.Fdrawing,F.Fsizespec,G.IDNAME AS UNIT,
B.FmaPrice,B.FintoQuty,B.FSum,
B.Fremark AS REMARK,E.idname AS DEPSC,
A.FdelGoNo,b.Fnumber
FROM tabAccountlistA AS A
LEFT JOIN tabAccountlistB AS B ON A.FfatherOddnumber=B.FfatherOddnumber
LEFT JOIN tabWarehouseIDS AS C ON A.Fwerehousenumber=C.IDno
LEFT JOIN tabBillCalssS AS D ON A.BILLCALSS=D.IDno
LEFT JOIN SqlDepSupCust AS E ON A.Fdeptnumber=E.idno
LEFT JOIN tabT_item AS F ON B.Fnumber=F.Fnumber
LEFT JOIN tabUnitIDS G ON F.Funit=G.IDno
WHERE A.Fpass=1 And A.FfatherOddnumber=@TxtIntoW
GO
在ACCESS中怎样调用这个存储过程,再把结果赋值给子窗体显示,
我服务器名称:ZHANGHA,数据库名称:mrpdata,
在此先谢谢各位了