Stored Procedures / Routines + general US startup questions

[Developer_J]

Happy to help. I expect the final release of 4.4 to be in the next few days, so might as well wait for that.

Hey Mudmin, et al,

I haven't had a chance to keep track of 4.4 release since the last message, hope it's going well. I have a follow up question regarding multiple result sets returned from a stored procedure please. 

I've had a look at the DB file and tried a few pdo ways to get a second (or third) result set and could not get anything to work externally ($result->nextRowset() <- does not exists error) nor see any fn in the DB file to do this for me.

For the time being I have created the following in the DB file, but I know this is not great as its a core US file. Could you tell me if I've missed something please or if there is a fn for this in US4.4?

Code:

    public function nextRowset(){
        if(!($this->_query->nextRowset())) return [];
        
        return $this->_query->fetchALL(PDO::FETCH_OBJ);
    }

Thanks