Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
Hi,
I am trying to insert values from thingworx to sql table but on testing of insert stmt written in thingworx am getting an error "Unable to Invoke Service Insert_WaitingReason_Details on Kirloskar_DB_Access : The statement did not return a result set."
How can I sort this issue. Please provide some idea.
Thanks,
V Shalini.
The problem is you have created the service as SQL Query type in the selection ,but ideally it should be as SQL Command type (Third selection in the dropdown ) .Run it with as SQL command type you will be able to insert if the written query is correct .
Thanks ,
Mukul Narang