Database Filter with quote characters?

Posted by Phil Birell on April 13, 2009

If I filter database BOOKS by writing something in the Filter property, I do this in the Object Inspector with for example: GENRE=FICTION

But how to this at runtime? In my code I tried Books.Filter=('GENRE=FICTION') and I tried Books.Filter=(GENRE='FICTION') and Books.Filter=('GENRE="FICTION"') but none of these work.

Also, how can I set up a filter at runtime based on text that was entered in a TEdit?
Books.Filter=('GENRE=Edit1.Text') is wrong, but how to do it right?

Follow Ups

• Re: Database Filter with quote characters? John, DelphiLand Team 4/15/2009 (2)
  • Why use the OnFilterRecord event? Phil Birell 4/22/2009 (1)
    • Use of OnFilterRecord event John, DelphiLand Team 4/23/2009 (0)