There are many ways to insert and update rows into a record either using Application Engine or Component Interfaces.
In Application Engine programe, using peopelecode we can create a standalone rowset with the record to be updated. Fill the rowset using rowset.fill method. Manipulate the data and use record.Save() method.

In Component Interfaces, if the record is in the CI buffer. If the data is populated in the buffer, the CI Save method will update or insert the data in the record.