I have created a procedure to write log messages.

CREATE PROCEDURE "SetLogMessage" (IN "Msg" VARCHAR(255) COLLATE ANSI_CI)
BEGIN  
  SET LOG MESSAGE TO Msg;
END

How do I view the log messages?

Richard Harding

Richard


The only way I know of is to use EDBManager. Open the session and there's an option to view the log.

Roy Lambert [Team Elevate]

>>The only way I know of is to use EDBManager. Open the session and there's an option to view the log.

Roy,

I did look there.  If I execute the procedure from an application, there is a log message with a notification for the Login to the session but no other message.

Richard Harding

Richard


Reading the OLH

Use this statement to create a new log message that can be retrieved and viewed by the application that is executing the current routine. The message can be any text that you wish.

So you should be able to view it. Unfortunately no hint is given as to how, but a bit of inspired guesswork - look at the TEDBScript component. There is an OnLogMessage event with parameters (Sender:TObject;  const LogMessage: string) and that's how you'll get it.

Roy Lambert

Thank you Roy . . .

>>So you should be able to view it. Unfortunately no hint is given as to how, but a bit of inspired guesswork - look at the TEDBScript component. There is an OnLogMessage event with parameters (Sender:TObject;  const LogMessage: string) and that's how you'll get it.

Richard Harding