Working with macrofunctions on UniDAC

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ivan_Carpio89
Posts: 29
Joined: Mon 10 Dec 2018 23:49

Working with macrofunctions on UniDAC

Post by Ivan_Carpio89 » Thu 07 Feb 2019 17:40

Hi.
I'm migrating from FireDAC to UniDAC and I want to know if there's any way to use this macrofunctions on UniDAC:

IFF
IFNULL
CONVERT
LENGTH
REPEATE
CONCAT
YEAR
CURDATE
TIMESTAMPDIFF
TIMESTAMPADD
NOW
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
ROUND
LTRIM
RTRIM
TRIM
POSITION
WEEK

I found on UniDAC's help some of those functions in the 'Unfied SQL' topic but most of them are not listed.

Im using UniDAC version 7.4.11 for RAD Studio XE7.

Ivan_Carpio89
Posts: 29
Joined: Mon 10 Dec 2018 23:49

Re: Working with macrofunctions on UniDAC

Post by Ivan_Carpio89 » Tue 12 Feb 2019 14:25

Any suggestions?

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Working with macrofunctions on UniDAC

Post by Stellar » Tue 12 Feb 2019 16:47

Yes, you are right. Common UniDAC features that are implemented at the moment are described in the "Unified SQL" topic of the online documentation.
https://www.devart.com/unidac/docs/unisql.htm#functions

If you want us to implement additional functions, please post them at our user voice forum:
https://devart.uservoice.com/forums/104 ... y_id=18939.
If the suggestion gets a lot of votes, we will consider the possibility to implement it.

Ivan_Carpio89
Posts: 29
Joined: Mon 10 Dec 2018 23:49

Re: Working with macrofunctions on UniDAC

Post by Ivan_Carpio89 » Wed 13 Feb 2019 02:02

For the moment, we will implement them, we already have something encoded, thanks.

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Working with macrofunctions on UniDAC

Post by Stellar » Fri 15 Feb 2019 09:10

Thank you for the interest in our products.
Feel free to contact us if you have any additional questions about our products.

Post Reply