Update query with certain parameters
Posted on 2013-02-06
I hope I can explain this without making myself sound an idiot.
I'm getting to grips with creating SQL adapters. I can create an update command with parameters and pass those values in for the update with no problem.
The disadvantage of this as far as I can see is that you have to create a new update command every time you want to change a record to reflect the changes that you are making at that point. My question is if it is possible to create a "global" update command for the table ( with all the columns in the table as parameters ) which will use the existing values for each column as the parameters values unless you provide new values for one or more of the parameters.
Does that make sense?