database - Delphi 6 : Cloning and Filtering of ADOTable -
i have dbgrid populated adotable (table1). need perform processing on data , show on other grid (popup).
i created temporary table (tbltemp) , assigned table1 it. problem facing that, if put filter on tbltemp, table1 modified accordingly. so, dbgrid in mainform changed.
if 1 closes pop-up, reset filter , mainform looks was. but, when pop-up present, , 1 moves pop-up, can see main form changed.
pfb code snippet :
tbltemp := tadotable.create(nil); tbltemp.recordset := table1.recordset; table1.disablecontrols; tbltemp.filtered := false; tbltemp.filter := ''; // valid filter tbltemp.filtered := true; datasource1.dataset := tbltemp; // data source in pop-up list dbgrid1.datasource := datasource1; // db grid in pop-up list is there way that, if apply filter on tbltemp , recordset of table1 not modified.
please provide inputs.
Comments
Post a Comment