Database Filter with quote characters?

Posted by Phil Birell p16812 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?