DBAdvGrid: insert value in a field

VCL TMS VCL UI Pack
1

Hello


I want to fill in some data in a field in the "OnCellValidate-event like this:

procedure TForm18.DBAdvGrid1CellValidate(Sender: TObject; ACol, ARow: Integer;
  var Value: string; var Valid: Boolean);
begin
  if ACol = 2 then
    DBAdvGrid1.DataSource.DataSet.FieldByName('field4').Value := 'Hello';
end;

where field4 is displayed i.e. in column 5. if I enter some data in column 2 the OnCellValidate is fired and I have my "hello" in column 5. But the data are not stored in the database. How have I to solve this?

Thanks, Peter