What is the NextRecordset method and why should I use it?
The NextRecordset method allows you to retrieve multiple results sets when you execute a query containing multiple select statements. Grouping multiple select statements together and executing them as if they were one statement gives us additional benefits like reduced network traffic and less code. Stored Procedures that return multiple result sets are also incredibly useful and efficient. The NextRecordset method lets us retrieve them all in a separate and organized manner. Before we create a connection, we need to direct the WorkSpace object to use the ODBC Cursor Library (a necessary prerequisite for using the NextRecordset method).
