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

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -

php - Controller/JToolBar not working in Joomla 2.5 -