Opening the SQLite db with an External tool

flydev · 2021-07-30 08:12:11

Hello,

Just to be clear, the project works - everything is fine.

I am used to explore the SQLIte database with SQLiteSpy, but this morning after an update of my mORMotClient unit and a compilation, when I open the DB with the tool (same with HeidiSQL) I have theses error, check the screenshot :

Sorry to post that, I dont want to scracth my head for hours trying to understand the error - any idea guys ?

ab · 2021-07-30 20:43:15

I guess it was always the case.

The "external" module is a mORMot specific module, which only redirect to an external SQL database.
So outside your project executable, you can't access this data. Because there is no data in SQLite for those tables, only in an external SQL DB.
You defined the Capteurs...Sorties tables as external in mORMot, so you see only their "virtual ghost" from the SQLite point of view.

flydev · 2021-07-31 08:33:22

Ok thanks - your comment make things clearer.

I didn't checked my code source right now but I don't remember to have changed something after my own post, but opening the same db while reading your post :

I will check if I changed something and will report here

PS: I dont mean there is a bug in mormot2, I am just trying to understand what's is going

ab · 2021-07-31 12:47:30

Nice you found out what the situation was.

mORMot Open Source

#1 2021-07-30 08:12:11

Opening the SQLite db with an External tool

#2 2021-07-30 20:43:15

Re: Opening the SQLite db with an External tool

#3 2021-07-31 08:33:22

Re: Opening the SQLite db with an External tool

#4 2021-07-31 12:47:30

Re: Opening the SQLite db with an External tool

Board footer