custom correlation

[taoh15]

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

[AlexP]

Hello,

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'

and use the following SQL query to enable the extensions:

Code: Select all

UniConnection.ExecSQL('SELECT load_extension(''C:\ext.dll'', ''sqlite3_ext_init'');');