I am not convinced that the documentation would lead you to expect that
Sum(numeric(9,2)) would not match a numeric(9,2) variable.

Maybe the documentation should warn that aggregates (and maybe any
mathematical operation) on scaled items may produce this error. Or maybe
the spec should be changed to fix it ;-) IMO its natural to expect EXECUTE
STATEMENT to be equivalent to using the statement itself.

Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Yemanov
> Sent: 07 April 2006 13:25
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support]Numeric Aggregates problem in
> EXECUTE STATEMENT
>
> "Paul Hope" <paulhope@...> wrote:
> >
> > so shouldn't the casting in <2> be an automatic under the
> hood thing
> > like
> it
> > appears to be in <3> so that <1> would work?
>
> Nope, EXECUTE STATEMENT does not perform any automatic
> casting. This is "as designed" and documented.
>
>
> Dmitry
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>