SQL Management Studio
Im feeling really dumb right now ( probably im) , but i dont get it...
You would like to see template node code executed in SMS?
write USE "DB-NAME" before the query (the first line)
As I asked right at the start
To which the answer was No!
Whenever something is not working, always work back from where the problem is seen to find at what point it goes wrong.
(1 row affected)
and when i try to execute 2nd time:
Commands completed successfully.
Only column i changed is date, as it converts to very long string.
after pasting this command (without) USE DB into node , still im gettings NULL's everywhere.
Can problem be in MSSQL-PLUS config?
I don't write any command in the mssql plus node.
the command is in the template - so this might be the reason.
remove any command you have written in mssql node - and just use the command we used in template.
mssql should use payload as the command
I think the command passed in from template is not getting used, as its using its own command, which might not be yielding any values
1 Like
Yes, it is working as expected with clean MSSQL-node!!!
Marcus, you are hero of the day! Without your solutions, I couldn't achieve this important flow for my project! Thank you very much for your effort!
Thanks @Colin for your engage!
And again its proven that node-red is borderless in any case/scenario!
p.s. now I have to clean up my flow, understand it and ofcourse testing testing testing!
Have a nice life guys!
2 Likes
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
