Registering user-defined functions

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Registering user-defined functions

Post by FredS » Sun 25 Jan 2015 21:09

I see this for the SQLiteUniProvider but not for others.

Does this mean there currently is no such functionality for other providers?

Thanks

Fred

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Registering user-defined functions

Post by AlexP » Mon 26 Jan 2015 09:01

Hello,

Support for user functions is implemented at the SQLite database level. Therefore this functionality is supported only in SQLiteUniProvider and in a separate product for SQLite - LiteDAC.

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: Registering user-defined functions

Post by FredS » Mon 26 Jan 2015 18:09

>>Support for user functions is implemented at the SQLite database level

Hi Alex,

Thank you for the quick reply.

To be clear, there is no way to add "SQL Functions" like the ones used here:
http://www.devart.com/unidac/docs/index.html?unisql.htm

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Registering user-defined functions

Post by AlexP » Tue 27 Jan 2015 12:02

Adding new SQL functions is not supported. You can only use already existing functions registered for each provider. If you have a version with source code, you can add the needed functionality by yourself.

Post Reply