In the UpdateRecord event, if UpdateKind is ukModify then there are 2 records that designate the important values. The first record contains old values, the second contains new values. In the event, the cursor will start on the second record. The following example forces a field called Test to UpperCase.

procedure TForm .UpdateSQLProvider UpdateRecord(DataSet: 
  TClientDataSet;  UpdateKind: TUpdateKind; 
  UpdateQuery: TQuery; var Applied: Boolean);
begin
  with DataSet do
  begin
    if (UpdateKind in [ukModify, ukInsert]) and
       (not VarIsEmpty(FieldByName('TEST').NewValue) then
      UpdateQuery.ParamByName('TEST').Value :=
    UpperCase(FieldByName('TEST').NewValue);
  end;
end;