Subject Re: FILTER From Heinz Kesting <Nobody@Nowhere.com> Date Thu, 23 Mar 2017 21:17:50 +0100 Newsgroups dbase.getting-started Hi Mustansir, > > I am using updateset to append a rowset2 from rowset1. I have applied filter condition to rowset1 > and after beginfilter() statement, when I append, all records of rowset1 are appended to rowset2. > To bring filter conditions into action, which were defined after issuing beginFilter(), you would have to issue applyFilter(), otherwise there will be no filter active. You could check the effect of the filter by looking for the number of rows in your rowset before you set the filter, and once more afterwards: ... ? "Number of rows before beginFilter() = " + form.rowset.count() ... form.rowset.beginFilter() ... // user enters here filter conditions form.rowset.ApplyFilter() ? "Number of rows AFTER applyFilter() = " + form.rowset.count() ... Hope that helps ... Kind regards, Heinz