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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Output type for SQL Insert

arunkumar1
12-Amethyst

Output type for SQL Insert

Hi,

I've created an SQL query service and added insert statement.

Though the insert statement successfully runs, I get "Unable to Invoke Service TestSQLInsert on MyDBThing : null".

The default Output type is INFOTABLE. Even after changing this output type to Long or anything, I get the same error.

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.

Regards

Arunkumar D

ACCEPTED SOLUTION

Accepted Solutions
qngo
12-Amethyst
(To:arunkumar1)

Hi,

I think it's a SQL Command rather than a SQL Query. Then the Output type could be a number.

Regards,

Quang-Dung

View solution in original post

1 REPLY 1
qngo
12-Amethyst
(To:arunkumar1)

Hi,

I think it's a SQL Command rather than a SQL Query. Then the Output type could be a number.

Regards,

Quang-Dung

Announcements


Top Tags