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
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.