custom correlation

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lakivihi
Posts: 1
Joined: Wed 13 Nov 2019 02:48

custom correlation

Post by lakivihi » Wed 13 Nov 2019 02:53

I have long been a user of Unidac for Delphi and I've been delighted with it, however I have now come across a problem.
I use a program called RootsMagic for my family history and it uses sqlite with a custom correlation RMNOCASE to store it's data. I use Sqlite Expert Professional to test queries with, but for it to work I have to add unifizz.dll as an extension to the 32bit Sqlite Expert.
Can I use this extension with Unidac Sqlite and if so how, please?

please check this xxx sites

https://freeporn.ooo
https://camjke.com
https://pornsites.pro
Last edited by lakivihi on Tue 17 May 2022 09:16, edited 1 time in total.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: custom correlation

Post by MaximG » Fri 15 Nov 2019 07:47

Our components allow loading external extensions: https://www.devart.com/unidac/docs/using-sqlite.htm ('EnableLoadExtension' option)

For example, you can try loading the unifuzz.dll library in the following way:

Code: Select all

     ...
     UniConnection.SpecificOptions.Values['EnableLoadExtension'] := 'True';
     UniConnection.Connect;
     UniConnection.ExecSQL('SELECT load_extension(''C:\unifuzz.dll'', ''sqlite3_extension_init'');');
     ...

Post Reply