Subject Re: [ib-support] how do you debug triggers and SPs ?
Author Doug Chamberlin
At 02/15/2002 09:48 AM (Friday), Nando Dessena wrote:
>I wrote:
>
> > Events are a way to send custom messages to the client, but they are
> > limited [...]
>
>additionally, I suddenly remembered that they are actually delivered on
>commit; a bit late to debug the internals of a stored procedure I
>fear...

If you have CodeSite 2.0 (a VERY good debugging aid for Delphi developers)
you can get IBSite 1.0 for free from
http://www.madrigal.com.au/products/ibsite/default.htm which allows for
near real-time debug messaging within triggers and stored procedures. UDFs
are defined and provided which send messages via TCP/IP sockets to your
debugging machine and are presented in a viewer window and/or logged to a
file. Very slick!

Codesite 2.0 is an inexpensive commercial product but IBSite 1.0 is a
freeeware addition.