case In Sensitive filtering on local dataset

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
steelsoft
Posts: 1
Joined: Thu 06 Aug 2020 10:42

case In Sensitive filtering on local dataset

Post by steelsoft » Thu 06 Aug 2020 10:46

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

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: case In Sensitive filtering on local dataset

Post by oleg0k » Fri 07 Aug 2020 08:39

Hello,
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];
wbr, Oleg
Devart Team

Post Reply