🚀 go-pugleaf

i cant seem to perform a query & tell my clientdataset what to delete,
then update the actual adodataset, like it's supposed to.  i have
problems, and to work around this i 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 out the correct method.  Please help...
 
                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;