我是这样做的,呵呵…… Dim rs As ADODB.Recordset Dim cn As ADODB.Connection Dim M, C As Single ……………… rs.Open "select max(XX),count(XX) from table", cn M = rs(0) C = rs(1) Debug.Print M, C
dim cmd as string Dim rs As ADODB.Recordset cmd.commandtext="select max(XX),count(XX) from table where 条件" set rs=cmd.execute
Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection
Dim M, C As Single
………………
rs.Open "select max(XX),count(XX) from table", cn
M = rs(0)
C = rs(1)
Debug.Print M, C
Dim rs As ADODB.Recordset
cmd.commandtext="select max(XX),count(XX) from table where 条件"
set rs=cmd.execute
所以用rs是达不到你的要求。
用command执行存储过程到是可以.
我试了一下,感觉loverface(双面人)的方法简洁实用,给20分。
其余给10分,大家不会有意见吧?再一次多谢大家!!!!