Hi, I have 11 function node, which result the 11 different types of value, that I want to insert into my sqlite table. I'd like to know, how can I do that, because I always get an error. Here is my code: var newMsg = { "topic": "INSERT INTO Database VALUES ( " + msg.payload.id + ", " + msg.payl…

[image] asdf123: because I always get an error. Without knowing what error you are getting, it's hard to know what to suggest. It usually helps to pass the message from your Function node to a Debug node (configured to display msg.topic so you can see exactly what query you are generating. I…

Okay, thanks, I found the problem in the debug node and fixed it. Now when I want to insert the data, I get this error: "Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: Database.ID" I checked the ID in excel, to filter out recurrence, but it didn't find anything.

Check in the database to see if any of the IDs already exist.

[nodered] Finally I'm allowed to upload, so here is my project. That's the error message I got now. I guess the problem is my insert function, which is like this now: var newMsg = { "topic": "INSERT INTO Database VALUES (" + "'"+id + "', " + "'"+value + "', " + "'"+a…

Hi. Its difficult to read code not formatted correctly. Please edit your post and put 3 backticks above and below code to preserve formatting and improve readability e.g. ``` Like this ``` Ps, your problem is likely due to updating msg.payload but then you return newMsg Edit. Now your code is …

As was suggested previously, if you have an error in the sql node the first thing to do is to look at what you are feeding into that node. Then you will be able to see what you ID values you are trying to insert.

[nodered] I cheked it as you said, and it seemed ok. All the values are listed below each other in each case. I cheked it with the debug node, and also I wrote it to a file.

Maybe my problem is that the insert function doesn't recognize the variables like ID. As far as I know, the function node only accepts a message for input. So what should I do with the ID function's result, to be recognizable to the insert function?

The reason you're not getting to the solution is you don't provide the right information for us to help. If you get an error - screenshot it Show the SQL you send to database. Show the schema of the database (i.e. is the database ID field a number field? A string Field? ) Additionally, you haven…

Insert into SQlite database?

General

Colin 10 May 2020 07:33 11

If that is supposed to be the output from a debug node showing what is going into the sql node, then you need to see msg.topic, which is where the query is, as you know. Change the debug node to Show Complete Message and try again.

Topic		Replies	Views
Insert csv. file to SQLite General	19	1272	1 April 2021
Insert data in sqlite without inject node General	3	666	26 January 2020
SQLite INSERT FUNCTION For random values General	5	1094	27 October 2021
Function to create data and insert into column of existing sqlite DB General database	8	355	6 January 2023
Receiving data from multiple nodes and uploading it to sqlite database General	13	1288	1 February 2021

Insert into SQlite database?

Related topics