Hi everyone. I looked almost all SQLite topic and didnt get solve my problem. I created a flow and testing local. Connected DHT11 and 1 cable for test. I can take sensor values and also GPIO port connected or not connected. But I didnt succeed it to save in DB at SQLİte. DB files is creating in m…

[image] knolleary: You have misunderstood what I suggested. I said to insert the string CURRENT_TIMESTAMP - instead, youv'e created a local javascript variable called CURRENT_TIMESTAMP, assigned it the value of Date.now() and insert that. Your Insert statement should start with: INSERT INTO Te…

wtrk 7 December 2020 06:31 61

I used Siemens S7 node for this and now its good. If you need I can share my node

Topic		Replies	Views
Sensor to node red to SQLite General	18	1372	15 November 2020
How to insert in a database? General database	47	2660	20 August 2022
Sqlite3 data insert problem General	29	2621	5 January 2022
Generate SQL statement from 2 mqtt messages General	39	1132	6 July 2020
Function to create data and insert into column of existing sqlite DB General database	7	370	6 January 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Saving Data in DB at SQLite Function - Help!

Related topics