Hello:

CREATE EXCEPTION TEST_EXCEPTION 'Test';

SET TERM ^ ;

CREATE PROCEDURE SP_EXCEPTION_TEST
RETURNS (
    ID INTEGER)
AS
BEGIN
  ID = 0;
  WHILE( ID < 10) DO BEGIN
    IF(ID > 5) THEN BEGIN
      EXCEPTION TEST_EXCEPTION 'Huch!!!';
    END
    SUSPEND;
    ID = ID + 1;
  END
END^

SET TERM ; ^

and then

"select * From SP_EXCEPTION_TEST"
Huummmmmmmm .............. oka i will retry with that thanks !!!!


--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to