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

[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 Iss

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"); tablasEstaticasDeUsuario.Tables["Espe

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 Down

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 ve

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

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 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 vers

[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] 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 > question > > I've posted on MSDN? > > http://forums.microsoft.com/MSDN/ShowPost.aspx?P

[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 exist.