Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

logSQL doesn't store SQL in txt file


#1

Hello,
I have 2 log connections: txt and binary. When tSiSession.logSQL() is called, the SQL command is stored in binary log. However it is not stored in txt log.

this is my call:
siMain.LogSql( lvdebug, ‘HPPC SQL’, SQL );

Text log contains only ‘HPPC SQL’

best regards
Piotr Rezmer


#2

Hello Piotr,

The reason for this is that the ‘text’ protocol does not output any attached data such as your sql query. The ‘text’ protocol is mostly intended for end-users and can only output the basic log entry properties such as the title, timestamp, log level, session name and so on. Since the attached data can also consist of binary data (such as a picture or a memory dump, for instance), the data wouldn’t be printable in all cases and we therefore decided to omit the attached data.