这是ACCESS中报表执行时赋值给报表的记录源:
Me.RecordSource = "SELECT A.Fpass,A.FfatherOddnumber,C.IDNAME AS WEREHOUSE," & _
"D.IDNAME AS BILL,A.Fdate,A.Fre," & _
"A.FwrikeMr,B.IDNo,F.FCname," & _
"F.Fdrawing,F.Fsizespec,G.IDNAME AS UNIT," & _
"B.FmaPrice,B.FintoQuty,B.FSum," & _
"B.Fre 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 " & _
"LEFT JOIN tabUnitIDS G ON F.Funit=G.IDno) ON B.Fnumber=F.Fnumber " & _
"WHERE (((A.Fpass)=True) And ((A.FfatherOddnumber)='" & Forms.frmWXgoHome.TxtIntoW & "'))"
Forms.frmWXgoHome.TxtIntoW是窗体上一个文本框内容要传递给语句,
求助,在SQL中怎样把这写成存储过程,再报表执行时调用这个存储过程赋值给报表记录源
在此先谢谢各位了
Me.RecordSource = "SELECT A.Fpass,A.FfatherOddnumber,C.IDNAME AS WEREHOUSE," & _
"D.IDNAME AS BILL,A.Fdate,A.Fre," & _
"A.FwrikeMr,B.IDNo,F.FCname," & _
"F.Fdrawing,F.Fsizespec,G.IDNAME AS UNIT," & _
"B.FmaPrice,B.FintoQuty,B.FSum," & _
"B.Fre 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 " & _
"LEFT JOIN tabUnitIDS G ON F.Funit=G.IDno) ON B.Fnumber=F.Fnumber " & _
"WHERE (((A.Fpass)=True) And ((A.FfatherOddnumber)='" & Forms.frmWXgoHome.TxtIntoW & "'))"
Forms.frmWXgoHome.TxtIntoW是窗体上一个文本框内容要传递给语句,
求助,在SQL中怎样把这写成存储过程,再报表执行时调用这个存储过程赋值给报表记录源
在此先谢谢各位了
解决方案 »
- ???如何将存储过程结果集与另一表合并 ???
- sql server2005中添加一int字段,默认值为设置为0,解决立刻结贴
- 如何连接两个不同地址不同类型数据库中的两个表
- 在建立与服务器的连接是出错。在连接到SQL Server 2005时,在默认设置下sql server 不允许远程访问,如下图
- 子网掩码的问题
- 光标,求救。
- 高手帮帮忙!SQLServer的安装问题
- 选择MS SQL Server的好处,送分了!!!!!!!!!!!!!!!!!!!!!!
- 得不到recordset啊!!
- Sql server 的分布式事务处理
- =100分=求证一个项目数据库设计的演化正确性和设计正确性!经验人员乱入!
- 查询和当前时间相比,处于一定范围内的,记录? 在线等。
as
SELECT A.Fpass,A.FfatherOddnumber,C.IDNAME AS WEREHOUSE,
D.IDNAME AS BILL,A.Fdate,A.Fre,
A.FwrikeMr,B.IDNo,F.FCname,
F.Fdrawing,F.Fsizespec,G.IDNAME AS UNIT,
B.FmaPrice,B.FintoQuty,B.FSum,
B.Fre 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
AS
SELECT A.Fpass ,
A.FfatherOddnumber ,
C.IDNAME AS WEREHOUSE ,
D.IDNAME AS BILL ,
A.Fdate ,
A.Fre ,
A.FwrikeMr ,
B.IDNo ,
F.FCname ,
F.Fdrawing ,
F.Fsizespec ,
G.IDNAME AS UNIT ,
B.FmaPrice ,
B.FintoQuty ,
B.FSum ,
B.Fre 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
LEFT JOIN tabUnitIDS G ON F.Funit = G.IDno
) ON B.Fnumber = F.Fnumber
WHERE ( ( ( A.Fpass ) = True )
AND ( ( A.FfatherOddnumber ) = @参数 )
)