Adding a record, but null is giving me problems

[danalynn]

I am adding a record to my sql database, in one field, bit field, there is not an entry for it so it needs to be null, well it won't let me add it because bit can't go null, what do i need to do?

i went into properties of the table and tried checking all null but it won't let me, how do i do this?

thanks

dana

 

[danalynn]

I fixed it so nm! The record would take a 0 instead of null and means the same thing in the field.

Thanks again

Dana

 

[foxdev]

I might disagree that 0 means NULL, but I know what you mean.

IIRC, this was changed in SQLS 7 so that bit datatypes could be NULLable. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[JamesJKusch]

Are you trying to enter the value of NULL? if so, a ctrl-0, control-zero, will place a null in that field if it has been set to accept nulls, even in a bit field.
J. Kusch