Thank you all for your advices.
@Derk J You should be able to ALTER TABLE and change the table.
It is far more easy:
at an early stage of development (and sometimes until late in the beta stage), I just trash the .sqlite file and modify y Create_SQLite Method. *
Here, I am at the beginning, doing test, seeking surprise (and that was one), and so on.
Searching a meeting by date / hour was super easy (as Derk wrote) and reliable.
I do not tried to seek all Mettings for the same hour or same day (what for if I provide a view by day ?)
(Stupid ?) Question:
What is the use to search meetings between two dates ?
* I implement the import/export methods somewhere between alpha and beta for this, so I will not have to risk my (sometimes) precious data nor use ALTER TABLE.
This is also a must if REPLACE is mis-used ;) an error is done so fast.
I usually add Import/Export when I have enough to type a record of-r two manually… ;)
I just added:
to my TABLE and it worked fine, anytime I try to add a brand new text with the same Date and Time (say 2019-06-15/ 10:00) it was silently rejected (excepted the first one, of course).
@Emile S what I have done in this regards
When I select a day and an hour (in another software), at OK click time, I checked if that “meeting” ** is free; else I issue a warning.
** In that specific case, a room # is involved, so the test was for the day, the hour and the room #.
How fast I am able to forget amaze me; good for books /magazine / video / movie; bad for developments…