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:
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.