Bit Datatype
- From: "Miro" <mironagy@xxxxxxxxxx>
- Date: Thu, 5 Jul 2007 08:35:28 -0400
I created a table with a bit datatype column.
I created this column as "do not allow null" and default value of 0
Now when I go into the Database explorer, right click on the table and click
on "show table data",
to manually add some of my own data into it. How do I actaully type in a
value on the bit field?
The only thing that is saving me is that the default value is there. But I
cant seem to type in a value,
either 0, 1 True / False Yes No .
It keeps giving me the same error,
Invalid Value for cell ( row 2, column 6 )
The changed value in this cell was not recognized as valid.
..Net Framework data Type: Boolean
Error Message: String was not recognized as a valid boolean.
Type a value appropriate for the data type or press ESC t ocancel the
change.
I cant quite figure out how to type in a value here.
I can make a form with a datagrid - then I have a checkbox so I can enter
data that way. But its annoying me I cant figure out how to do this here.
Thanks
Miro
.
- Follow-Ups:
- Re: Bit Datatype
- From: Göran Andersson
- Re: Bit Datatype
- From: Mark S. Milley, MCSD (BinarySwitch)
- Re: Bit Datatype
- Prev by Date: Re: Making ListViewItems not selectable
- Next by Date: Re: MAIN FORM from PROCESS ?
- Previous by thread: Making ListViewItems not selectable
- Next by thread: Re: Bit Datatype
- Index(es):