You are not logged in.
- Topics: Active | Unanswered
#1 2020-01-16 09:34:37
- keinn
- Member
- Registered: 2014-10-20
- Posts: 103
Sqlite db created by mORMot Framework can Not be operated by 3rd tools
Database created by mORMot Framework can Not be operated by 3rd tools
like Navicat
take Sqlite3\sample\ 30 - MVC Server for demo,
navicat can open and do select Query operation
but write operation like Insert will trigger an error:
no such collation sequence: SYSTEMNOCASE
Offline
#2 2020-01-16 12:39:31
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
I think you'll have to disable those mORMot's built-in collations, I can't tell the details so please check the document.
Last edited by edwinsn (2020-01-16 12:41:47)
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#3 2020-01-16 14:28:14
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
Just inherit from TSQLRecordNoCase or TSQLRecordCaseSensitive instead of plain TSQLRecord, if you don't want to use SYSTEMNOCASE.
You can also override the procedure InternalDefineModel() but it is a bit more verbose.
Offline
#4 2020-01-17 00:20:13
- DelphiRio
- Member
- Registered: 2020-01-17
- Posts: 2
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
Hi @ab
If the db created with mORMot by using a password, it can't be open in any 3rd tools. Would you please use https://github.com/utelle/wxsqlite3 for the db engine. It is shipped with encryption and 3rd tools can use the dll from there to open the db files.
This help a lot when debugging because I can take a look into the db, execute SQL query and see the result in 3rd tools.
Thank you very much!
Offline
#5 2020-01-17 02:55:38
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
You can use wxsqlite3 with mORMot with the dynamic linking mode. Search 'wxsqlite' in https://synopse.info/files/html/Synopse … 01.18.html
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#6 2020-01-17 05:00:16
- DelphiRio
- Member
- Registered: 2020-01-17
- Posts: 2
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
I know the dynamic linking mode. I mean static link mode! wxlsqlite provides full source code with encryption and can be built with C++Builder for linking into the app!
Last edited by DelphiRio (2020-01-17 05:02:54)
Offline
#7 2020-01-17 09:46:01
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
There is no standard encryption way with SQlite3.
The wxlsqlite version is not standard either.
Our SynDBExplorer tool handles our encryption scheme, and allow to inspect the DB files.
If anyone is willing to find out what is wrong with Delphi XE4 linking bug, and provide a fix, you are welcome!
Offline
#8 2020-01-17 10:04:45
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools
If anyone is willing to find out what is wrong with Delphi XE4 linking bug, and provide a fix, you are welcome!
I guess your last line was intended to reply "Delphi 64bit sqlite compilation" ( https://synopse.info/forum/viewtopic.php?id=5127) 
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline