You may right. By changing to CASE(SUM(..) as INTEGER) or CASE(SUM(...) as NUMERIC(15, 4), it worked.

Thanks

William

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 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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




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

---------------------------------
YAHOO! GROUPS LINKS


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

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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
http://mail.yahoo.com

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