I prefer to use filtering on local dataset - not to call query and
request data again from SQL server.
With fileds of 'numbers' types it is usually without problems.
But when it comes to text/varchar its more complex to support
local filtering in CASE-insensitive mode and even using LIKE statement.
Is it possible to apply local filtering on your LocalDataset (query
component) using statement "customer LIKE '%ro%'" returning records
containing 'Roman' as well as 'Carol' in customer field?
Thanks
case In Sensitive filtering on local dataset
Re: case In Sensitive filtering on local dataset
Hello,
To enable case insensitive filtering by text fields, you need to set the foCaseInsensitive option under FilterOptions to True. For example:
wbr, Oleg
Devart Team
To enable case insensitive filtering by text fields, you need to set the foCaseInsensitive option under FilterOptions to True. For example:
Code: Select all
PgQuery.FilterOptions:=[foCaseInsensitive];
Devart Team