Subject Re: [firebird-support] Re: Execute Statement BUG
Author Wei Yu
You may right. By changing to CASE(SUM(..) as INTEGER) or CASE(SUM(...) as NUMERIC(15, 4), it worked.



Dimitry Sibiryakov <SD@...> wrote: On 20 Dec 2005 at 19:53, Wei Yu wrote:

> I did investigate the problem for detail. It ends up that everything
> went to OK, if you return a empty dataset. BUT got error if there
> are data needs to be returned. and futher, if I comment the SUM(..)
> fields and GROUP BY clause. then I get the result set from this for
> execute statement. so IT MUST BE A BUG in the current version of
> FireBird.

It may be a bug, but not the bug you expect. The fact that FB does
not automatically convert types in EXECUTE STATEMENT is not a bug -
it is by design.
You can call 'a bug' that SUM(integer) may be not integer but this
is a different story.

SY, Dimitry Sibiryakov.


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Technical support services


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


William, Yu

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

[Non-text portions of this message have been removed]