[solved] SQLite3 Without and with datamodule
lazarus / 16-Databases

----------------------------------------------------------------------
folkeu08 · 2021-01-18 12:56

Hi all,
I am in the preparatory phase of a software working with an SQLite3
database.
I write the routines that allow me to write, edit and delete data in
the database.
I went through a step where the connection to the database and
processing components (Query and datasource) are in the form.
Everything works wonderfully. (SQL_TEST_V2.rar)
My next step is to place these components in a Datamodule. I made the
necessary changes but I have an error when launching the "External:
SIGEGV" exception class and I do not understand what could cause it.
(SQL_TEST_V3.rar).
You must add the 2 files sqlite3.def and sqlite3.dll in the folder of
the executable. It's too big for add it in a zip in this forum.
Thanks in advance.

----------------------------------------------------------------------
folkeu08 · 2021-01-19 15:00

Hello,
I found the why.
The initiation of the database should not be done when the Main_form
(OnCreate) is created, but when the Main_Form (OnShow) is displayed.
By moving the 'Initialize' process in an "OnShow" event, the exception
no longer occurs
Fanch

----------------------------------------------------------------------
JanRoza · 2021-01-19 17:22

I've never needed file sqlite3.def in the applications folder just
putting sqlite3.dll is enough to get my database application running.