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
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...
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
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
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
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);
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