I have a Data Table created in my Schema which gets the records from a stored procedure execution. The stored procedure returns results which were inserted in a Table variable in my procedure’s code. I want to update a couple of fields of that recordset and I wrote a second procedure for that. Then I created a New Command in the Schema Modeler calling the update procedure and assigned it to my Data Table’s UpdateCommandName. When updating, the command is called successfully and the changes are done in DB but I get the following Exception:
“Problem during executing RefreshDataset. Original error was: [SafeCall Exception]: Incorrect syntax near the keyword ‘WHERE’.”
Was it the issue here, should the refresh work correctly?