来自数据透视表的VBScript RecordSet.RecordCount

问题描述

我正在尝试从RecordCount ReDim我的数组，问题是我的查询使用PIVOT表然后RecordSet.RecordCount返回-1



我知道我可以做两次，一次用于计数和移动数据用于处理数据

count = 0

而非Recordset.EOF

count =计数+ 1

Recordset.movenext

Wend



有另一种获取此信息的方式吗？



感谢您的时间。

解决方案

Hi, I´m trying to ReDim my array from RecordCount, the problem is my query use PIVOT Table and then RecordSet.RecordCount return -1

I know that I can do two while, once for count and movefirts to works with data
count = 0
While Not Recordset.EOF
count = count + 1
Recordset.movenext
Wend

There is another way to get this information?

Thanks for your time.

解决方案

这篇关于来自数据透视表的VBScript RecordSet.RecordCount的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！