General Update Statements

Updating A Column Value In A Table


"UPDATE SomeTableName SET SomeColumnName=" + Convert::ToString(NewValue) + " WHERE SomeColumnName=" + Convert::ToString(IdValueOfRecordToAlter)

Assumes MyNewValue is numeric, otherwise surround with ‘ and ‘

Update 2 Column Values


"UPDATE SomeTableName SET SomeColumnName1=" + Convert::ToString(NewValue) + ", SomeColumnName2=\'" + NewString + "\' WHERE SomeColumnName=" + Convert::ToString(IdValueOfRecordToAlter);