Subject Re: [firebird-support] Re: SP Urgent!!!
Author Martijn Tonies
> No problem was not in the tool itself.

If executing the actual procedure raises an exception, and
debugging the procedure (which does not execute it) doesn't
raise an exception, I'd say there's something wrong there.

>I changed
> If(exist) to a new statement
>
> select 1 from RDB$Database
> Where ...
> Into :numrows;
> If (numrows is not null) then
> exception;
>
> and then everything was OK. It seem that problem was related to
> IF (exists) command.

With regards,

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