CRDBGrid - Error on Filtering, Problem on Search on specific column names

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

CRDBGrid - Error on Filtering, Problem on Search on specific column names

Post by ertank » Wed 13 Jan 2016 16:40

Hi,

I am using MSSQL 2014 Express as a database. Delphi 10 Seattle for coding. I have an SQL statement like below.

Code: Select all

SELECT Ad,Soyad,OncekiSoyadi as 'Önc.Soyadı',TCNo,SGKNo as 'SGK No',Cinsiyet,Istihdam as 'P/Y',Aktif,CalismaDurumu as 'Çalışma Durumu' FROM PERSONEL
When I use such a statement, I don't need to deal with column titles for easier understanding.

Result set is displayed in a CRDBGrid. When I try to filter first 4 columns there is no problem. And, when I try to filter 5th column (which has name of "SGK No" in result set) I get error message saying "Field SGK not found"

I have same problems on 7th column (P/Y).

I doubt Filtering cannot work with column names with spaces or special characters in a query result set.

Moreover, when I try to search on that 5th field only first character is searched. Typing following characters and nothing happens.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: CRDBGrid - Error on Filtering, Problem on Search on specific column names

Post by AlexP » Thu 14 Jan 2016 10:28

Hello,

Thank you for the information. We will try to fix this behaviour in the nearest future.

ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

Re: CRDBGrid - Error on Filtering, Problem on Search on specific column names

Post by ertank » Wed 06 Jul 2016 19:25

Dear Alex,

Is there any update about this problem?

Thanks.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: CRDBGrid - Error on Filtering, Problem on Search on specific column names

Post by AlexP » Thu 07 Jul 2016 08:24

No, this problem is not yet fixed

Post Reply