Change value BeforeUpdateExecute

[[email protected]]

Hi,

I want to alter some field-values before the update of the query occurs.

Code: Select all

procedure TDataModule1.q_anredeBeforeUpdateExecute(
  Sender: TCustomMSDataSet; StatementTypes: TStatementTypes;
  Params: TMSParams);
begin
  Sender.FieldByName('myfield').Text := 'test';
end;

But this doesn't work. Is this the correct way to solve this or how is this done?

[Jackson]

The TCustomDADataSet.BeforeUpdateExecute event is not designed for such tasks.
Use the TDataSet.BeforePost event instead.