[Firebird-net-provider] COALESCE in select

2007-08-03 Thread Ji�� Neuil
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

Re: [Firebird-net-provider] Design Time - Invalid connection string

2007-01-29 Thread Ji�� Neuil
:) 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 =

Re: [Firebird-net-provider] Design Time - Invalid connection string

2007-01-29 Thread Ji�� Neuil
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

[Firebird-net-provider] Generated UPDATE, DELETE command for TableAdapters

2006-01-24 Thread Ji�� Neuil
Hi, I have this problem with generated UPDATE and DELETE commands for TableAdapter: Everything works perfect until I remove filter from some columns in Query builder in VS 2005. Then SourceColumn property from all parameters @IsNull_Column is set to null and DbType is set to AnsiString(should

[Firebird-net-provider] Generated UPDATE command for TableAdapter

2006-01-13 Thread Ji�� Neuil
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

[Firebird-net-provider] .NET 2.0 Provider, UPDATE and DELETE command are not generated by TableAdapters

2005-12-11 Thread Ji�� Neuil
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