> Well
> I use Firebirds 1.5 and ROW_COUNT work on Insert, Update and Delete and I
> thought exist something for Select.

In Firebird 2, it works with SELECT as well.

> Ok I use INTO

Well, the current requirement for SELECT says it always
needs an INTO clause.

> Another question: suspend after exception is not necessary?

SUSPEND is __only__ needed if you want to return values to
the calling application and __only__ if you intend calling the
procedure with SELECT.

Do not use it for executable procedures.


Besides, anything after EXCEPTION will not be executed
anyway.


Oh, if you want to check the existence of records, why not
use:

IF (NOT (EXISTS(your select statement)))
THEN EXCEPTION ...


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com