Used to change the WHERE clause of SELECT statement and reopen a query.
property FilterSQL: string;
The FilterSQL property is similar to the Filter property, but it changes the WHERE clause of SELECT statement and reopens query. Syntax is the same to the WHERE clause.
Note: the FilterSQL property adds a value to the WHERE condition as is. If you expect this value to be enclosed in brackets, you should bracket it explicitly.
Query1.FilterSQL := 'Dept >= 20 and DName LIKE ''M%''';