[fpc-pascal] logging fcl-db (sql) actions

[Michael Van Canneyt]

On Sat, 30 Jul 2016, Marco van de Voort wrote:

>
> I've done a little program with fcl-db's sqlite connection. I sometimes have
> the feeling I miss edits.
>
> Does fcl-db have something to log all sql actions (like sql logger from
> zeos) ?

Yes.

Global hook:

http://www.freepascal.org/docs-html/current/fcl/sqldb/globaldbloghook.html

Per connection hook:
http://www.freepascal.org/docs-html/current/fcl/sqldb/tsqlconnection.onlog.html

Control per DB what events are logged:
http://www.freepascal.org/docs-html/current/fcl/sqldb/tsqlconnection.logevents.html


Michael.