You forgot SQLite has a Data Changed Notification, too.
I didn't forget, I didn't know.
Does that mean that you're volunteering to add it to the LCL components? At the moment they only support PostgreSQL and Firebird :-)
MarkMLl
Hell no! Whatever gave you that idea? I'm still bumbling around a lot.
I'll probably come up with a class-helper for sqlite3conn, but that's about it.
There is one thing you have to consider with this Data Change Notification in SQLite3: You cannot use the same db-connection to call a refresh for, which actually committed the update (at least that's how i understand it).
Basically it boils down to:
Have/use 2 sqlite3conn-Objects
Register the callback-function with dbconn1 (and that's the one you use for CUD (NOT C
RUD), but use dbconn2 to do the reads/display
https://www.sqlite.org/c3ref/update_hook.html