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

2007-06-27 Thread Carlos Guzmán Álvarez
Hello: this is the exception: System.ArgumentException: System.FormatException: String was not = recognized as a valid Boolean. As Dean has pointed out yet the field values should be valid for a boolean conversion in .net

[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] 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] 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);

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