|Subject||Re: [firebird-support] Using Null as parameter in Stored Procedure|
> >The weird thing is that I am using IBExpert to create and edit all myOr, it does show runtime errors but the debugger has a bug in handling
> >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.
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.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL