> >The weird thing is that I am using IBExpert to create and edit all my
> >FireBird psql, and when I use the built-in debugger I am able to walk
> >through my code and view the results that I am expecting.
>
> Debuggers don't execute the SP code, so you won't see run-time errors
> during debugging.

Or, it does show runtime errors but the debugger has a bug in handling
NULLs and automatically converts the SQL statement to IS NULL
instead of doing the = NULL like the procedure is doing :-)

You might want to check IBExperts SQL trace for this.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com