1 Topic by prezmer

  • prezmer
  • Guest

Topic: logSQL doesn't store SQL in txt file

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 Reply by tgurock

  • tgurock
  • Administrator
  • Offline
  • Registered: 2009-07-09
  • Posts: 628

Re: logSQL doesn't store SQL in txt file

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.