recordcount总返回-1
如下:
sql1 = "select DISTINCT(B001) from ABC "
rs.Open sql1, cnn, adOpenKeyset, adLockOptimistic
rs.recordcount总返回-1
当去掉DISTINCT就正常了
sql1 = "select B001 from ABC "
rs.Open sql1, cnn, adOpenKeyset, adLockOptimistic
但我想去掉重复的部分,不只如何实现
请帮帮忙哦