CodeIgniter Forums
sqlsrv_next_result() in Codeigniter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: CodeIgniter 3.x (https://forum.codeigniter.com/forumdisplay.php?fid=17)
+--- Thread: sqlsrv_next_result() in Codeigniter (/showthread.php?tid=80227)



sqlsrv_next_result() in Codeigniter - hermes.tas - 10-01-2021

Hello world!

I am currently wondering about this.

If I have a Stored Procedure that includes 2 or more queries as below

Code:
ALTER PROCEDURE [dbo].[selectAllTables]
AS
 SELECT * FROM customers
 SELECT * FROM orders
GO;


To execute those queries and recieve the result 1 by 1, I can do


PHP Code:
sqlsrv_next_result() 

But how to do sqlsrv_next_result() using Codeigniter active record?

Is there something like

PHP Code:
$this->db->next_result() 


in Codeigniter ?