Hello! I have created a UI like this: </> [immagine] When I press the button 'CARICA' I would insert the inserted data to an SQL table (already created). Which flow can I use? How can I pass inserted data to the SQL table (I have the flow for the connection to the SQL database. Many thanks

Ah, apologies. [ { "id": "bce72d0f261b67cb", "type": "ui_button", "z": "7c13b8452619581b", "name": "", "group": "2733e4a59af46689", "order": 4, "width": 0, "height": 0, "passthru": false, "label": "Carica", …

Here is a solution (one of many on the forum) It uses a form so that all dashboard inputs arrive at the SQL node at the same time. [image] Dashboard and MS SQL database - number and text input nodes Dashboard Hi Naz. Firstly, one thing to realise is that messages NEVER …

Thank you Steve, this can help me! I installed the suggest node of MSSQL plus, but I don't see the same format (I continue to see the format for the SQL standard node) </> [immagine] Another question: for the Form node, do you know if it is possible to include dropdown menu for some field?

You need to remove the 5y old MSSQL node & restart node-red

[image] QGIO: Another question: for the Form node, do you know if it is possible to include dropdown menu for some field? No, the UI form doesnt have a drop down. In your case you probably need to use individual components & store the values in rediness for when the button is pressed. Did y…

yes, I see but but I don't see the information inside the node Store and Get. Do you have suggestion also for JOIN node?

[image] QGIO: yes, I see but but I don't see the information inside the node Store and Get They are just change nodes. Very basic. I think maybe you are new to node-red? I'll post a couple of canned replies below that will help... See this article in the cookbook for an example of how to …

is it correct to use for uninstall the old </> npm uninstall -g node-red-contrib-mssql and than install this new </> npm install node-red-contrib-mssql-plus`

Depends where you installed it in the first place. Typically, it is installed in your node-red folder (not global) CD into your .node-red folder then run npm uninstall node-red-contrib-mssql

In this case, what I have to send to the button ? </> [immagine] I have three separate variables (as in the flow reported in the example)

Pass data throught a button to SQL Table

General

zenofmud 10 March 2022 10:47 2

How is this different from your prior thread RequestError: Incorrect syntax near '.'

Topic		Replies	Views
Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database Dashboard	34	19121	3 May 2019
UI Dropdown - get result from SQL Dashboard	50	18959	12 November 2018
Creating form then logging entry in SQL General	15	441	21 May 2021
Hello! I'm trying to extract the data from an sql server into a table from my dashboard but i dont get the table filled. My version of node-red is v3.0.2, Windows, and i'm running a Docker Dashboard database	17	417	17 December 2023
Dashboard-2-sqlserverDatabase-crud Dashboard dashboard-2	5	293	8 July 2024

Pass data throught a button to SQL Table

Related topics