Devart Forums

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.

Any suggestions?

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.

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

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