Symptoms

>Query] Are we able to change the "required field" of the smartobject"Update" method? I do not want to only update a table where the condition is only WHERE to the primary key. I know this can be done by Stored Procedure but it is tedious to do it as there are many columns in the table to update.
 

Diagnoses

None


 

Resolution

It will not be possible to do so as the SQL server service type uses the primary key of the table to execute updates. Apart from creating a stored procedure, you may create your own service type and write the code to perform the update in the way you prefer.