0 Replies Latest reply on Oct 15, 2015 9:46 AM by green.kim.twsp RSS
    green.kim.twsp Explorer

    Usage of SQLCommand Handler in a Database Thing

    I am not able to get the SQLCommand handler to do anything. I can run the SQLQuery handler and it will update, insert and add to tables in the database Thing. Is there a specialized format for the SQLCommand handler? I get 2 errors in the Application log that appear in random order:

    • Throwable message: null
    I would ideally like to run a stored procedure to insert a new row and values passed through via parameters into a table and then just have the number of rows affected returned as the result. The SQLQuery handler is expecting an infotable back but when you do an update or insert there is no returned set of values.