I have a relatively big SQL SELECT query (44 lines). On the locally deployed sqlite database query works. On the server query works as well (server is the machine, where node-red runs + database file is deployed). From the node-red the query returns empty [ empty ] This is the flow I use: [{"id…

Sqlite select query not returning data

Petr 15 October 2019 19:50 5

nr 0.19.5
node.js v10.16.3
catch node doesn't return any error/msg (I thing because query just return nothing)

What schema do you mean?

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	11	973	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	14	185	20 December 2022
Node-red returns empty when sending query to Microsoft SQL Server General database	5	165	1 February 2023
Help with a Select Query Function General	13	1493	12 March 2020
Node-RED select sqlite db and transform the date into an object with arrays General	5	749	2 January 2022