This content has been marked as final. Show 4 replies
Which database, and what is the datatype of the column?
The database used is MS SQL 2000
and the datatype is bit
Within your query, just CAST() your bit field to int, and it will display its integer value in CFGRID.
SELECT CAST(your_bit_col AS int) AS new_col_name,
Thanks, that is a good solution.
But I did something else.
I thought a little about it and i think that true and false sayes more than 1 and 0.
Therefore I desided to keep that. Insted I did the following.
When I'm about to save the data I use sp_columns to get the Type_Name from the table.
If the Type_Name is bit I convert the true/false to 1/0