Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2016-07

logging fcl-db (sql) actions

2 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Marco van de Voort

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) ?

Michael Van Canneyt
to Marco van de Voort
Marco van de Voort wrote 6 lines
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.