[Firebird-net-provider] Enhacement for FBCommand

2007-06-26 Thread Mercea Paul
Hi I face with this situation: Some customers want to have reports or export 'patterns' from fb database. For that I have some possibilities as sql query or stored procedures. For query I make all by code. For stored procedures I have 2 situation, first, SP exist in database, second SP not

Re: [Firebird-net-provider] TransactionScope

2007-06-26 Thread Carlos Guzmán Álvarez
Hello: Hi! I think we touch upon this before but completely abandon TransActionScope can some of your guys take a look at this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250SiteID=1question I've posted on MSDN?

[Firebird-net-provider] Mapping a database char column to a DataTable boolean column

2007-06-26 Thread Andres F. Moschini
I wish to map a the BOOLEANO domain column as a boolean column in a datatable. CREATE DOMAIN BOOLEANO AS CHAR(1) CHARACTER SET NONE DEFAULT 'F' NOT NULL CHECK (value in ('T', 'F')) COLLATE NONE is it posible? thanks, sorry about my bad english...

Re: [Firebird-net-provider] Mapping a database char column to a DataTable boolean column

2007-06-26 Thread Jiri Cincura
You've to do it on client side by casting it to true/false. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-26 Thread Jiri Cincura
On 6/26/07, Mercea Paul [EMAIL PROTECTED] wrote: SP exist in database, second SP not exist. If SP exist , just run, etc. For this case it would be useful to have a method to check if SP exist in database, if not, recreate procedure. (this works only for FB2 I think, for FB 1.x just create).

Re: [Firebird-net-provider] Mapping a database char column to a DataTable boolean column

2007-06-26 Thread Andres F. Moschini
Andres F. Moschini escribió: I wish to map a the BOOLEANO domain column as a boolean column in a datatable. CREATE DOMAIN BOOLEANO AS CHAR(1) CHARACTER SET NONE DEFAULT 'F' NOT NULL CHECK (value in ('T', 'F')) COLLATE NONE is it posible? thanks, sorry about my bad

Re: [Firebird-net-provider] Mapping a database char column to

2007-06-26 Thread Carlos Guzmán Álvarez
Hello: But, then, I can't use DataAdapter to fill a DataTable with boolean = Try setting the column in the DataTable structure as boolean - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-26 Thread Carlos Guzmán Álvarez
Hello: How can FBCommand (re)create procedure? FBCommand has no idea about internal code of procedure. And anyway that shouldn't be responsability of the provider ... - This SF.net email is sponsored by DB2 Express

Re: [Firebird-net-provider] Mapping a database char column to

2007-06-26 Thread Andres F. Moschini
Carlos Guzmán Álvarez escribió: Hello: But, then, I can't use DataAdapter to fill a DataTable with boolean = Try setting the column in the DataTable structure as boolean do you mean that? tablasEstaticasDeUsuario.Tables.Add(Especificaciones);

[Firebird-net-provider] [FB-Tracker] Created: (DNET-98) FirebirdDDEX v2.0.1.0 broken after installing FirebirdClient 2.1.0.0 RC1

2007-06-26 Thread Mike Bluett (JIRA)
FirebirdDDEX v2.0.1.0 broken after installing FirebirdClient 2.1.0.0 RC1 Key: DNET-98 URL: http://tracker.firebirdsql.org/browse/DNET-98 Project: .NET Data provider

Re: [Firebird-net-provider] Mapping a database char column to

2007-06-26 Thread Dean Harding
I'm using .Net 1.1, Fb 1.5 and Firebird Net Provider 1.7 maybe it works with new versions? I wouldn't think so, T and F are not recognised by .NET as strings representing true or false (i.e. Convert.ToBoolean(T) or Convert.ToBoolean(F) are what is throwing that exception). You've got three