Cannot enter a 0 or 1 in a BIT datatype

[johncassell]

Hi there,

I have an SQL Server Express 2005 database with a column (Hire_Ticked) in it with a datatype of BIT. All i want from it is basic "yes/no", "true/false" data entry so I thought BIT was best datatype.

Even though it says BIT can only accept 0 or 1, if I enter either of those it comes up with the error below..

Any ideas?

Thanks

John

 

[CygNuS]

Via code you can use values 1 or 0, but when changing the value manually like you are doing, use True or False.

 

[johncassell]

Brilliant,

worked perfect.

Thanks very much CygNus

 

[Arg81]

That's interesting. Must be a SQL Server Express 2005 thing.

I'm using SQL Server 2000 and in my Bit columns I can type 0 or 1...

If I type true it changes to 1 automatically as does false to 0

Must remember that!