mORMot Open Source

F.Logeas

Member

Registered: 2019-02-11

Posts: 1

SynSQLite3 priority over SQLite3.dll

Hi, we are currently investigating conflict in our mORMot base(incorrect collate causing some records to not return when using where "logonname = x"), and we are wondering wether, when both are presents, who get priority between SynSQLite3static.pas and sqlite3.dll ?

Basically, we have an unit, using another unit that use SynSQLite3Static, and in the release folder (after compilation) we have a sqlite3.dll needed for operations on non-mormot databases.

In this case, will said unit prioritise(use by default) SynSQLite3Static, or the sqlite3.dll present in the release folder ?

Thanx in advance

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,656

Website

Re: SynSQLite3 priority over SQLite3.dll

If SynSQLite3Static is linked to the executable, it will be used.

But you can change this behavior by setting the global SQlite3 variable from SynSQLite3 to an external .dll file, if needed.

About collation problems, inherit from TSQLRecordNoCase opr TSQLRecordCaseSensitive classes instead of TSQLRecord.
Or call Props.SetCustomCollationForAll(sftUTF8Text,'...') overriding TSQLRecord.InternalDefineModel.