Posted by Phil Birell p16812 on April 22, 2009
In Reply to Re: Database Filter with quote characters? posted by John, DelphiLand Team on April 15, 2009Hi, 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?