Big problem crdbgrid FILTER with SDAC

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tom0201
Posts: 5
Joined: Wed 17 Jan 2007 17:20

Big problem crdbgrid FILTER with SDAC

Post by tom0201 » Fri 19 Jan 2007 11:20

Big problem crdbgrid FILTER

when i use crdbgrid without SDAC, the filter is not case sensitiv

Example:
FILTER is set on field "NAME" (varchar(50)) = Habelmann

records found:
habelmann
Habelmann
HABELMANN

When i use SDAC, only one record is found:
Habelmann

What can i do, that all three records were found?

tom0201
Posts: 5
Joined: Wed 17 Jan 2007 17:20

Re: Big problem crdbgrid FILTER with SDAC

Post by tom0201 » Fri 19 Jan 2007 15:03

tom0201 wrote:Big problem crdbgrid FILTER

when i use crdbgrid without SDAC, the filter is not case sensitiv

Example:
FILTER is set on field "NAME" (varchar(50)) = Habelmann

records found:
habelmann
Habelmann
HABELMANN

When i use SDAC, only one record is found:
Habelmann

What can i do, that all three records were found?
I found the solution:
in crdbgrid -> OptionsEx -> dgeLocalFilter = False
in crdbgrid -> OptionsEx -> dgeLocalSort = False

Post Reply