[fpc-pascal] Re: RE : SQLDB: logging all generated SQL?

[Reinier Olislagers]

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