Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
How can I write something in the result parameter, using mssql and a SQL command.
When I try:
SET [[result]] = 2;
I get:
result
-1
Kind regards,
Simon
Have you set the service input to "SQL Command"? What happens when you do "SET @result=2;" ?
Using @result gives following error
Unable to Invoke Service TestSet on IDFoee_Enterpirse1_Site6 : Must declare the scalar variable "@result".
Declaring the variable does not help, since you are making it a local variable, not one that can be accessed from the Thingworx scope.