Subject Re: [ib-support] showmessage in SP
Author Doug Chamberlin
At 12/29/2001 12:36 AM (Saturday), Claudio Valderrama C. wrote:
>"KURSAT TASKIN" <kursatt@...> wrote in message
> > is there any way to get a message in procedure under interbase?
> > I want to get a message but not an exception during procedure proceed?
> > Thanks
>ShowMessage in the engine? Who would do that? Who would have to be in the
>server machine to see the message and click the OK button? A procedure runs
>in the server, don't see a fit for ShowMessage there. It doesn't make sense
>for me.

The only reason I can see to do this is for debugging. I have written UDF
which logs messages to a log file on the server.

I have also written an extension to CodeSite which allows stored procedures
and triggers to generate CodeSite entries. CodeSite is a popular debugging
tool for Delphi users which sends messages to a viewer or log file or
another machine. This makes it very easy to watch IB server procedures run
in near real time. The message dispatching is very efficient and flexible.

See for more info.

I'll be releasing the Codsite UDF extensions as open source sometime in January.