I have 2 UDFs. One puts up a message box and the other logs to a text
file.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Hans
> Sent: Wednesday, 26 July 2006 9:31 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Re: Debugging Stored Procedures
>
> > When I was searching this newsgroup for debugging messages,
> I saw that
> > someone was using a UDF to output debugging messages to a log file.
> > It does seem like finding a way to return the messages is
> part of the
> > trick.
> >
>
> I just add a bunch of extra returning variables to the
> procedure and add extra 'suspends with an at # line number
> and returning the current values of variables of interest .
> Now calling the developing procedure from say IBOConsole, or
> IB_Wisql making checking and debugging very easy under real
> conditions.
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Yahoo! Groups gets a make over. See the new email design.
> http://us.click.yahoo.com/WktRrD/lOaOAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>