TCustomConnectionDataSets (Delphi)

Description

The following code fragment illustrates how DataSets and DataSetCount can be used to ensure that an action is taken for every open dataset. Assign CheckButtonActive as the AfterClose and AfterOpen event handlers for TClientDataSet1.

Code

procedure TForm1.Button1Click(Sender: TObject);
var
  I: Integer;
begin
  if not RemoteServer1.Connected then
    RemoteServer1.Connected := True;
  ClientDataSet1.Close;
  with RemoteServer1 do
  begin
    for I := 0 to DataSetCount - 1 do
      DataSets[I].EnableControls;
  end;
  ClientDataSet1.Open;
end;

procedure TForm1.Button3Click(Sender: TObject);
var
  I: Integer;
begin
  ClientDataSet1.Close;
  RemoteServer1.Connected := False;
  with RemoteServer1 do
  begin
    for I := 0 to DataSetCount - 1 do
      DataSets[I].DisableControls;
  end;
end;

procedure TForm1.CheckButtonActive(DataSet: TDataSet);
begin
  Button1.Enabled := not ClientDataSet1.Active;
  Button2.Enabled := ClientDataSet1.Active;
  Button3.Enabled := ClientDataSet1.Active;
end;

Uses

• Data.DB.TCustomConnection.DataSets ( fr | de | ja )
• Data.DB.TCustomConnection.DataSetCount ( fr | de | ja )
• Data.DB.TDataSet.EnableControls ( fr | de | ja )
• Data.DB.TDataSet.DisableControls ( fr | de | ja )
• Datasnap.DBClient.TCustomClientDataSet.Active ( fr | de | ja )
• Data.DB.TDataSet.AfterClose ( fr | de | ja )
• Data.DB.TDataSet.AfterOpen ( fr | de | ja )