Recordset and stored procedure 1

[davideart]

Hi everybody.
I use to open MS SQL Tables via ADO (using the recordset object).
I'm facin' this problem: I open the recordset using a stored procedure as object source:

MyRec.Open "exec sp_spaceused",MyConn

This SP returns two different sets of record...but my recorset object only contains data from the first one.....how can I retrieve the second sets returned by the SP?
Any help is great, Thanks in advance!
Dave

 

[sunaj]

Hi,

Open the recordset with the command object and use .nextrecordset to fetch the next recordset.
See

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q182290

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[davideart]

Thanks very much, you've been very helpful
Dave