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
Posts: 1
Joined: Mon 12 Apr 2021 07:05

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.

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.ExecSQL('SELECT load_extension(''unifizz.dll'')')

Post Reply