I've been messing with the crDBGrid.
I am working on the logic to apply a filter, when the data source is a query.
I don't want to add to the filtersql of the query, because the query is long and complex, but adding the filter 'Name like %Mark% is returning 0 rows, even though there are several 'marks'....
Is it possible to use extended filters like this on a table/query?
If so, how?
If not, How can I implement it?
Filter on a query
To specify the text of the filter for a dataset you should use the following code:
Code: Select all
MyQuery.Filter := 'FieldName like ''%mark%''';