Delphi DASQL functions not working

Data Abstract
1

Using Delphi 11.2 with RemObjects Data Abstract for Delphi, Server Edition - 10.0.0.1555.exe. Custom build server using Delphi.

When we are running DASql statements with some functions, they are not running.

2023-12-15_09-46-15
2023-12-15_09-46-15889×58 78.8 KB

The error we are getting is:

2023-12-15_09-45-04

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?

2

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.

3

Hi,

what actual DB (MSSQL, MySQL, PostrgeSQL, FireDAC, etc) are you using?

7

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?

Thanks.

8

Hi,

You are using ODBC connection so DA can’t detect correct connection type and use methods of specific DB.