On 9/26/18 7:59 PM, mohamed hamza wrote: > Using OnFilter event is more appropriate I believe ? > It depends on your needs. OnFilterRecord is used for local filtering.
> Nb: > > Function TSQLQuery.AddFilter(SQLstr : msestring) : msestring; > > > Is never called from tmsebufdataset ? > Correct, tmsebufdataset has no SQL property. I assume that you expect that tmsebufdataset composes a new SQL query from the edited values in dataset dsFilter state. It does not because it is too error-prone and limited and also has the security risk of SQL injection. Better setup the filtered query yourself and use params. Martin _______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk