CRDBGrid - Error on Filtering, Problem on Search on specific column names
Posted: 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.
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.
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 PERSONELResult 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.