FireDac Odbc is what we are using for the DA connection.
DASql with Like and Equal work just fine. We really need to use functions in our sql calls. Using the Dynamic Where was just too time consuming for the hundreds of forms we have.
What could the reason for this not working? Is there something we do not have turned on on the server side?
Short answer is right there in the message: this expression is not supported. Note that DA SQL is a subset of the “full” SQL spec (which vastly differs between database engines, too), and does (and will) not support any and all SQL queries you can imagine.
We are using the FireDAC components from Delphi 11.2 Enterprise on a Sybase ASA database thru an ODBC connection.
Funny thing is that even though the DA documentation says it supports length and trim and ltrim and rtrim, they are not working at all. We tried them individually, not just with the example that I shot the screen of. This is a Delphi server. Are these only supported in the .Net version?