Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
2 posts • Page 1 of 1
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.
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'')') ...