Posted by Phil Birell on April 13, 2009If 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?