🚀 go-pugleaf

thedeak@ntslink.net (ryan) wrote in message news:<2fa56e32.0401160827.647e1449@posting.google.com>...
> 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;

i know someone has to have the answer out there....