如何让ADO来操作SQL语句，高手请进！

[canic]

select min(办单号) as aa, 颜色 , sum(数量) as bb from (select * from design_zs_color where 办单号='dfg' union all select * from design_bj_color where 办单号='dfg') as UnionTbl group by 颜色
在SQLserver Query Anelyzer中所搜出四条记录
单用ADODB.recordset操作时却只有-1条记录，说没有行标签。
用a.field!aa可以读取第一条记录得数据的数据行。但不能用movenext等操作。
实在觉得迷惑！请高手指点如何才能把搜索出的记录让ADO读出！

[minajo21]

打开方式？

[uvmusic]

ADODB.recordset操作时却只有-1条记录，说明并没有找到所需要的记录集

[fling_boy]

With Rs
'使recordcount>0
.CursorLocation = adUseClient
.CursorType = adOpenStatic
'可以修改和保存
.LockType = adLockOptimistic
End With

[desrie]

可能是ado設置有問題
rs.CursorLocation = adUseClient
rs.open sql,conn,adOpenKeySet,adLockOptimistic,adCmdText

[IwantFlay]

用的打开方式不对吧.

[FLchengang]

cn.open "........."
rs.open "select min(办单号) as aa, 颜色 , sum(数量) as bb from (select * from design_zs_color where 办单号='dfg' union all select * from design_bj_color where 办单号='dfg') as UnionTbl group by 颜色",cn,1,3
do whiule not rs.eof
msgbox rs(0)
rs.movenext
loop
rs.close
cn.close
set rs=nothing
set cn=nothing

[I_Iverson]

检查bof和eof，if not bof then movefirst
还有估计和CursorLocation有关