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?
Cheers
Taoh
custom correlation
Re: custom correlation
Hello,
Yes, you can use SQLite extension in UniDAC. For this, you need to enable the EnableLoadExtension option:
and use the following SQL query to enable the extensions:
Yes, you can use SQLite extension in UniDAC. For this, you need to enable the EnableLoadExtension option:
Code: Select all
UniConnection.SpecificOptions.Values['EnableLoadExtension'] := 'True'
Code: Select all
UniConnection.ExecSQL('SELECT load_extension(''C:\ext.dll'', ''sqlite3_ext_init'');');