🚀 go-pugleaf

i cant seem to perform a query & tell my clientdataset what to delete,
then update the actual adodataset.  i have problems, so i have to
activate my clientdataset after the query for my adodataset (so the
right query is stored) then tell it what to delete & update, then
close my clientdataset again.  this is a pain & i'd like to know the
correct way.  this method currently requires i have my forms point to
my ado dataset instead of my client datasets..i know this is wrong,
but cant figure it out.


DataModule3->ClientDataSet4->Active = true;
                DataModule3->ClientDataSet4->Edit();
                if(DataModule3->ClientDataSet4->State == dsEdit)
                {
                        DataModule3->ClientDataSet4->Delete();
                        DataModule3->ClientDataSet4->ApplyUpdates(-1);
                        Application->MessageBox("Record
deleted.","Status", MB_OK);
                        DataModule3->ADOCommand1->CommandText =
"SELECT LoginName, UserRightsLevel FROM AUTHTABLE";
                        DataModule3->ADODataSet2->Recordset =
DataModule3->ADOCommand1->Execute();
                };
                DataModule3->ClientDataSet4->Active = false;