Subject | Re: [firebird-support] Re: conditions on results |
---|---|
Author | Alberto Pesce |
Post date | 2006-02-08T08:29:06Z |
Ok,
I will verify that my variable in INO is clean and is never used before
It's correct so?
Thanks
Alberto
I will verify that my variable in INO is clean and is never used before
It's correct so?
Thanks
Alberto
----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, February 07, 2006 11:16 PM
Subject: [firebird-support] Re: conditions on results
> > Another question: suspend after exception is not necessary?
>
> After you call exception, no other code is executed (unless you have a
> when ... do block which handles the exception), so in your procedure
> it will do absolutely nothing and is not required.
>
> An explanation to your other problem is that
>
> select blah
> from table
> into :blah
>
> will not affect the contents of the variable blah if no result is
> returned by the select. This can be a 'gotcha' as some people expect
> it to be null, but in truth it will be whatever it was before the
> select was run.
>
> Adam
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>