[Firebird-net-provider] COALESCE in select
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
Re: [Firebird-net-provider] Design Time - Invalid connection string
:) I have read Is select command hardcoded, sorry :) Jiri Cincura [EMAIL PROTECTED] pí¹e v diskusním pøíspìvku news:[EMAIL PROTECTED] Jir=ED Neuzil wrote: Yes, it's hardcoded: from master form ctor.: this.fbConnection =3D new = FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionString= ()); = this.fbCommand =3D new FirebirdSql.Data.FirebirdClient.FbCommand(Select = * = from podnik, this.fbConnection); This isn't harcoded. :) Just guessing, try to put the string *directly* into ctor. Maybe this helps. -- = Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=3Djoin.phpp=3DsourceforgeCID=3DDE= VDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Design Time - Invalid connection string
So I hardcode connection string to master form ctor: this.fbConnection = new FirebirdSql.Data.FirebirdClient.FbConnection(C:\ageu\ageu.fdb); this.fbCommand = new FirebirdSql.Data.FirebirdClient.FbCommand(Select * from podnik, this.fbConnection); but, it doesn't help. Thanks Jiri Cincura [EMAIL PROTECTED] pí¹e v diskusním pøíspìvku news:[EMAIL PROTECTED] Jir=ED Neuzil wrote: Yes, it's hardcoded: from master form ctor.: this.fbConnection =3D new = FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionString= ()); = this.fbCommand =3D new FirebirdSql.Data.FirebirdClient.FbCommand(Select = * = from podnik, this.fbConnection); This isn't harcoded. :) Just guessing, try to put the string *directly* into ctor. Maybe this helps. -- = Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=3Djoin.phpp=3DsourceforgeCID=3DDE= VDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Generated UPDATE command for TableAdapter
Hi, I have this problem with generated UPDATE command for TableAdapter: Parameters for UPDATE command, which started with @IsNull_ColumnName have DbType Int32, but if I have for expamle column CompanyName with value Microsoft, there is value Microsoft in @IsNull_CompanyName parameter(I try to debug XdrStream.cs, public void Write(Descriptor descriptor) function)and all parameters @IsNull_ are DbType Int32... so I get exception Thanks. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] .NET 2.0 Provider, UPDATE and DELETE command are not generated by TableAdapters
Hi, I have a problems with .NET 2.0 Firebird .NET DataProvider(Firebird Client 2.0 Beta 1) I successfully integrate them with visual studio 2005 RTM, but TableAdapters generate only insert command, not update and delete? Thanks --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider