Well

Thanks very match
Alberto

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, February 07, 2006 4:34 PM
Subject: Re: [firebird-support] conditions on results


>
>
> > 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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>