----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: abhisekb Message 2 in Discussion Hello Arun, The SP that you have written would actually return three recordsets. In order to access the remaining two recordsets, you need to use the NextRecordset feature of ADODB recordsets. Basically, when you execute the command object the recordset returned is actually a collection of recordsets with the first one being accessible by default. After accessing the values from the first recordset( i.e. values for "SELECT * FROM vw_ViewA"), you need to perform the operation : rsLocal1.NextRecordset in order to access the remaining recordsets in the collection. Note: The nextrecordset option only works if the connection is being maintained and is also within the same process boundary. Let me know if you face any problems regarding this. Cheers, Abhisek ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
