In addfilter sql ________________________________ De : Martin Schreiber <mse00...@gmail.com> Envoyé : jeudi 27 septembre 2018 05:48 À : mseide-msegui-talk@lists.sourceforge.net Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for MSEide+MSEgui)
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
_______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk