Why does the SQL.active property need to be set to true to select a row in the database via TADOQuery, but not to insert it?

Question

Delphi

Hello. There is such a code.

procedure TFormMain.Button7Click(Sender: TObject);
begin;

  FormMain.QueryOrganizer.SQL.Clear;
  FormMain.QueryOrganizer.SQL.Text := 'INSERT INTO Органайзер ' +
  '([Код поручения], [Код работника]) ' +
  'VALUES ' +
  '(1, 1)';
  FormMain.QueryOrganizer.ExecSQL;
 
  FormMain.QueryOrganizer.SQL.Clear;
  FormMain.QueryOrganizer.SQL.Text := 'SELECT * FROM Органайзер;';
  FormMain.QueryOrganizer.Active := true;
  FormMain.QueryOrganizer.ExecSQL;
  ShowMessage(FormMain.QueryOrganizer.FieldByName('Код').AsString);

  FrameOrganizer1.DBGrid1.Datasource.Dataset.Close;
  FrameOrganizer1.DBGrid1.Datasource.Dataset.Open;

end;

If you comment out the line
FormMain.QueryOrganizer.Active := true;
Then SELECT will not work - a popup will be issued with the message "QueryOrganizer: Field 'Code' not found". However, INSERT will still work. Why is that?

Answer 1

Because it INSERTdoes not return the "Code" field.