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

2007-08-04 Thread Jiri Cincura
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


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

2007-08-04 Thread 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


[Firebird-net-provider] COALESCE in select

2007-08-03 Thread Ji�� Neu�il
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.

Tkank you for advises. 



-
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