topic Output type for SQL Insert in ThingWorx Developers https://www.ptcusercommunity.com/t5/ThingWorx-Developers/Output-type-for-SQL-Insert/m-p/502627#M1252 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've created an SQL query service and added insert statement.</P><P></P><P>Though the insert statement successfully runs, I get "Unable to Invoke Service TestSQLInsert on MyDBThing : null".</P><P></P><P>The default Output type is INFOTABLE. Even after changing this output type to Long or anything, I get the same error.</P><P></P><P>What is the correct output type I should use? Is it right to have INSERT/UPDATE statements in SQL Query service? If not what is the approach I should use for writing INSERT/UPDATE statements.</P><P></P><P>Regards</P><P>Arunkumar D</P></BODY></HTML> Wed, 16 Mar 2016 04:52:41 GMT arunkumar1 2016-03-16T04:52:41Z Output type for SQL Insert https://www.ptcusercommunity.com/t5/ThingWorx-Developers/Output-type-for-SQL-Insert/m-p/502627#M1252 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've created an SQL query service and added insert statement.</P><P></P><P>Though the insert statement successfully runs, I get "Unable to Invoke Service TestSQLInsert on MyDBThing : null".</P><P></P><P>The default Output type is INFOTABLE. Even after changing this output type to Long or anything, I get the same error.</P><P></P><P>What is the correct output type I should use? Is it right to have INSERT/UPDATE statements in SQL Query service? If not what is the approach I should use for writing INSERT/UPDATE statements.</P><P></P><P>Regards</P><P>Arunkumar D</P></BODY></HTML> Wed, 16 Mar 2016 04:52:41 GMT https://www.ptcusercommunity.com/t5/ThingWorx-Developers/Output-type-for-SQL-Insert/m-p/502627#M1252 arunkumar1 2016-03-16T04:52:41Z Re: Output type for SQL Insert https://www.ptcusercommunity.com/t5/ThingWorx-Developers/Output-type-for-SQL-Insert/m-p/502628#M1253 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think it's a SQL Command rather than a SQL Query. Then the Output type could be a number.</P><P></P><P>Regards,</P><P>Quang-Dung</P></BODY></HTML> Wed, 16 Mar 2016 08:19:53 GMT https://www.ptcusercommunity.com/t5/ThingWorx-Developers/Output-type-for-SQL-Insert/m-p/502628#M1253 qngo 2016-03-16T08:19:53Z