Re: [Firebird-net-provider] COALESCE in select

[Meuzil]

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