Hi, thanks for reply, yes, same server (FB 2.0.1), same DB.
This is the command:
select sum(o_osev.plocha) as plocha,sum(s_sumsklizen.suma) as
vynos,z_hon.nazevhon, o_plodina.plodnazev, coalesce(s_prumcena.prumcena,0) from
o_osev
left join o_odruda on o_osev.idodruda = o_odruda.odrkod
left join o_plodina on o_odruda.plodid = o_plodina.plodkod
left join s_prumcena on o_plodina.plodkod = s_prumcena.plodkod
left join z_hon on o_osev.idhon = z_hon.idhon
left join s_sumsklizen on s_sumsklizen.idosev = o_osev.id
group by z_hon.nazevhon, o_plodina.plodnazev, s_prumcena.prumcena.
I have copied it to VS 2005 TableAdapter designer, to
TableAdapter.SelectCommand (many others select commands works fine).
Thanks.
Původní zpráva
Od: Jiri Cincura [EMAIL PROTECTED]
Předmět: Re: [Firebird-net-provider] COALESCE in select
Datum: 04.8.2007 09:59:38
On 8/4/07, Jiøí Neu¾il [EMAIL PROTECTED] wrote:
Hi, I'm using Firebird .NET DataProvider 2.1 RC1 and when I use
coalesce(decimal_column, 0) in my select command I get:
SQL Execution Error.
Executed SQL Statement: SELECT..
Error Source: Firebird.Data.FirebirdClient
Error Message: Dynamic SQL Error
SQL error code = -804
Function unknown
coalesce
If I execute same SQL command in IBExpert everything is OK.
This is error from FB server. Are you using same server as connecting
from IBE? What's the version? How looks the command in code?
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider