On 26-4-2012 11:27, Ludo Brands wrote: >>> I vaguely remember somebody mentioning SQLDB has the option >> of dumping >>> to a log all the SQL it sends to the database (in other >> words: logging >>> all SQL sent to the database). >>> >>> Can somebody tell me if that functionality is there and >> where to find >>> it? Perhaps something to do with TSQLConnection.LogEvents? >> >> That's the one. > Just to be clear. The logging happens at the level of TSQLQuery and > TSQLTransaction and will record events such as prepare, execute, commit, > rollback, etc. SQL strings are as known at that layer (ie parameters are not > expanded). Database layers that use data binding will never expand > parameters and use a proprietary protocol to send the data to the database.
Thanks, guess you must have read my forum post as well ;) It makes sense parameters are not expanded; I'll just have to see what the logging contains. Thanks, Reinier _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
