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);

Read More