🚀 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;


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 1/13/2004