cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

SQL command result

sdejager
1-Newbie

SQL command result

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

2 REPLIES 2
posipova
20-Turquoise
(To:sdejager)

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.

Announcements


Top Tags