Bit data type in SQL server

[rpal]

I am converting CR 8 to CR 9 versition as database is SQL server 7.

In pts_change_log table there is column called change_closed, data type of this column is "bit" and data stored in the column as 1 or 0. When i am trying to access this column in Crystal Report 9.0 (in CR 8 this column showing as 1 or 0.) it is showing as 'True' or 'Fals' , does any body know why it is converting to Boolean value?.

thanks,
raj.

 

[vidru]

Probably because that's what BIT fields are primarily used for. You should be able to right click the field on the report, and format it to show 1 or 0 instead of true or false (Boolean tab).

-dave

 

[synapsevampire]

So the logic you're using doesn't work now?

I'm wondering if the difference you're experiencing isn't the result of a different type of connectivity.

BTW, In SQL Server 7, bit types cannot be null nor be indexed.

-k