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
