bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Multiple queries doesn't show multiple record set #76

Closed Ubbialil closed 2 weeks ago

Ubbialil commented 1 year ago

I'm trying to execute a multiple query but the node return only one recordset instead of two.

Node image

PRINT 'start'

SELECT TOP 5 * 
FROM SBODemoIT.dbo.[OITM]

SELECT TOP 5 *
FROM SBODemoIT.dbo.[OCRD]

PRINT 'complete'

Return As you can in the following screenshot it return only one recordset (array(5)) instead of two recordsets.

image

The sqlinfo property is filled correctly with the 2 prints.

Steve-Mcl commented 2 weeks ago

To get multiple record sets, chose driver output.

The "Original Output" mode is for backwards compatibility for those upgrading from node-red-contrib-mssql which never supported this feature.