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…

[image] Petr: I have a relatively big SQL SELECT query (44 lines). Respect for being able to read that! Could you post the query to me as a PM?

have you put in a catch nde connected to a debug node (display complete msg) to see if anytheing is reported? What version of nr and node.Js? Can you provide your schema?

Both queries (working and not-working) are included in the "template node" in the flow posted above.

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?

The database schema - the create table's syntax to show what al the columns are

There is not a problem in the database schema, AFIK. The table is really simple CREATE TABLE IF NOT EXISTS "POWER" ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT, "TIMESTAMP" DATETIME NOT NULL DEFAULT (datetime(CURRENT_TIMESTAMP,'localtime')), "TOTAL_KWH" NUMERIC); I can get the data with the same SQL s…

Sorry I haven’t been able to get back to this. (Family issues and a wind storm cleanup) I hope ll have time later today

No problem, thanks for taking care anyway...

Well you're going to kick yourself. Try removing the first line (the create index) and see what you get.

Hmmm. I see. Query is returning data when first row is removed. But why it is not working with the first row? When I run whole query (including the first row) from CLI and from DB browser for SQLite the query is working....

Sqlite select query not returning data

General

zenofmud 20 October 2019 00:59 14

Sure, send the first to the sql node then check the output to see it ran and if it did connect to another node to build the next sql statement and feel it to another SQLite node. Or you could put the SQLite node in a sub flow so you only have one instance of it.

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	10	1168	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	13	380	20 December 2022
Select data from SQlite not working General	1	380	26 January 2022
Inconsistent SQLite node query behaviour General database , sqlite	10	158	26 November 2024
Help with Sqlite Select clause General	5	608	5 January 2020

Sqlite select query not returning data

Related topics