||
Sub printMyProcResults(startDate as Date, endDate as Date)Dim db as DAO.DatabaseDim qf as DAO.QueryDefDim rs as DAO.RecordsetSet db = CurrentDb()Dim db as DAO.DatabaseSet qf = db.CreateQeuryDef("") ' 创建临时的查询' 如果存储过程有记录返回,设置为 True,否则设置为 Falseqf.ReturnRecords = True' 设置 SQL Server 数据库的 ODBC 连接字符串qf.Connect = "ODBC;DRIVER=SQL Server;SERVER=MYSERVER;Trusted_Connection=Yes;DATABASE=MYDATABASE;"' 构造传递查询的 SQL 语句,示例:myStoreProc 起始日期, 结束日期qf.SQL = "myStoreProc '" & Format(startDate, "dd mmm yyyy") & "'," & _"'" & Format(endDate, "dd mmm yyyy") & "'"' 打开返回的记录集Set rs = qf.OpenRecordSet()' 在立即窗口打印记录集内容Do While Not rs.EOFdebug.print rs(0)rs.MoveNextLooprs.Close' 清理Set rs = NothingSet qf = NothingSet db = NothingEnd Sub
|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )
GMT+8, 2024-7-4 10:47 , Processed in 0.093980 second(s), 17 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.