Bit Field Null?

darian1271 · #1 01-22-2003, 10:27 PM

Stanley writes "Ok from what I know you can create a bit field but when doing so in Enterprise Manager you are not allowed to have a NULL value and if you have a column that you are trying to make into a Bit field you must put a value in each field or assign a default value. However a couple of my co-workers ran into an issue of almost every Bit field being set to accept NULL values. They should not be that way and no one seems to know what happened. Is there some bug or hack that can alter this? Is is possible for someone to script the change?"

Arwen_04(EA) · #2 01-27-2003, 02:01 AM

Quote:

Originally posted by darian1271
Stanley writes "Ok from what I know you can create a bit field but when doing so in Enterprise Manager you are not allowed to have a NULL value and if you have a column that you are trying to make into a Bit field you must put a value in each field or assign a default value. However a couple of my co-workers ran into an issue of almost every Bit field being set to accept NULL values. They should not be that way and no one seems to know what happened. Is there some bug or hack that can alter this? Is is possible for someone to script the change?"

Hi,
You know I tried once in MS Access to have null value in my database.
database will accept null values only if the field is not your PKey.

JBane · #3 01-28-2003, 11:15 AM

Bit fields can be created to accept null values, though it defeats the purpose. They were more than likely created this way to begin with.

Jeff