Why use the OnFilterRecord event?

Posted by Phil Birell on April 22, 2009

In Reply to Re: Database Filter with quote characters? posted by John, DelphiLand Team on April 15, 2009

Hi, here's another question about filtering DataSet :)

It seems that with an OnFilterRecord event handler I can do the same as with the Filter property, only it's more complicated.

I have to write explicitly which dataset and wich fields to use (such as Books.FieldByName('Title').AsString = ...)

If I want to simulate a case-insensitive filter, I found out that I must use the function UpperCase(). And also the wildcard character * doesn't work.

So what's it good for? Am I missing something?

Follow Ups