How to log SQL params? lazarus / 31-LCL ---------------------------------------------------------------------- Milsa · 2013-10-14 12:33 I found article on wiki about logging: http://wiki.freepascal.org/SqlDBHowto#Troubleshooting:_TSQLConnection_ logging I have logged SQL queries. I need to log params for SQL query: Code: [Select]SQLQuery.SQL.Text := 'SELECT * FROM table WHERE name=:name ORDER BY name'; //logged in TSQLConnection.OnLog SQLQuery.Params.ParamByName('name').AsString:='Surname'; //params are empty in OnLog ---------------------------------------------------------------------- BigChimp · 2013-10-14 14:11 As the article hints/indicates, you can't. Unless you modify sqldb; if you have a good patch, it's very welcome. ---------------------------------------------------------------------- Milsa · 2013-10-14 14:42 I think that I will do it with creating TSQLQueryLogging from TSQLQuery. TSQLQueryLogging.Open will log params and call original Open method. It is the easiest method. Thank you for your help.