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=FICTIONBut 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?
Related articles
Follow Ups
- Re: Database Filter with quote characters? John, DelphiLand Team 4/15/2009
(2)
- Why use the OnFilterRecord event? Phil Birell p16812 4/22/2009
(1)
- Use of OnFilterRecord event John, DelphiLand Team 4/23/2009
(0)
- Use of OnFilterRecord event John, DelphiLand Team 4/23/2009
(0)
- Why use the OnFilterRecord event? Phil Birell p16812 4/22/2009
(1)
Post a Followup
DelphiLand Club members: enter your Membership password.
Guests can get a Forum Guest password by subscribing to the DelphiLand Newsletter.