Subject | Re: [ib-support] how do you debug triggers and SPs ? |
---|---|
Author | Doug Chamberlin |
Post date | 2002-02-15T14:55:12Z |
At 02/15/2002 09:48 AM (Friday), Nando Dessena wrote:
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.
>I wrote:If you have CodeSite 2.0 (a VERY good debugging aid for Delphi developers)
>
> > 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...
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.