Bug when setting the filter with a field name ending with"."

[michellenweiter]

In the version 6.20.011 of ODAC, everything works fine, but since after this version, when you set the filter using a field name ending with a "." ODAC produces an error telling that this field name is not found.

Ex :

MyOraQuery.sql := SELECT
EMP.EMPNO,
EMP.ENAME AS "Name.",
EMP.JOB,
EMP.SAL
FROM
EMP

MyOraQuery.filter := [MyFieldname.]='Something'

Thanks for fixing this issue.
mitch

[Plash]

ODAC have never supported field names with '.' in the filter.

ODAC 6.20.0.11 has a bug that accidentally resulted in the fact that your code was working.

When a field name contains the dot, ODAC searches for an actual field name but not a field alias. So if you have a table that has a field containing the dot, you can use it in the filter. If you have a SQL query with an alias, you cannot use it in the filter.

We cannot fix this behaviour because the fix will break compatibility with previous ODAC versions.

[michellenweiter]

You wan't break the compatibility with the previous version if you fix it, because it has always worked this way until your version 6.20 included.