Unifizz with Unidac Sqlite

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
xDestynyx
Posts: 1
Joined: Mon 12 Apr 2021 07:05
Contact:

Unifizz with Unidac Sqlite

Post by xDestynyx » Wed 21 Apr 2021 13:44

Hi. 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? Thanks.

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

Re: Unifizz with Unidac Sqlite

Post by MaximG » Thu 13 May 2021 14:17

UniDAC allows loading extensions. The following code fragment shows how to load 'unifizz.dll' :

Code: Select all

 ...
  UniConnection.ProviderName := 'SQLite';
  UniConnection.SpecificOptions.Values['Direct'] := 'True';
  UniConnection.SpecificOptions.Values['EnableLoadExtension'] := 'True';
  UniConnection.Connect;
  UniConnection.ExecSQL('SELECT load_extension(''unifizz.dll'')')
 ...

Post Reply