Error with FILTER TOracleDataSet

[bigwizard]

I made query:
SELECT empno "Code of Emp"
, empname "Name of Emp"
FROM emp
and then I tried to set filter:
qrySearch.Filter := '"Code of Emp" = 10 ';
qrySearch.Filtered := true;
but It isn't worked with error "Syntax error"
How can I repair?

 

[Marco Kalter]

The mixed case identifiers are not handled properly by the filter. As a work around you can omit the column aliases and set the DisplayLabel of the fields.

------------------
Marco Kalter
Allround Automations