TOraQuery issue in ODAC 9.2.5

[mikeho]

Running this simple query in a TOraQuery is causing issues:

select nameid, usertype, groupid, userstatus,
facility, chgfacility, allcusts, publicaccts
from userheader
where nameid = :in_user

This is always returning no records. This query works fine when I revert back to ODAC 9.1.4.

Connecting to the userheader table with a TOraTable component and setting FilterSQL to Format('nameid = ''%s''', [edtUser.Text]); works fine in ODAC 9.2.5. It returns the same record the query does with 9.1.4.

What has changed in the TOraQuery from 9.1.4 to 9.2.5 to prevent the above query from working properly?

[AlexP]

Hello,

We have already fixed the problem, the fix will be included to the next version of ODAC, that will be released this week.

[mikeho]

Happy to report the problem was resolved with the 9.2.6 release.

Thanks

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.