sql server table error NEWBE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
I am using sql server 2005 express management studio. I made a table
with a Bit datatype. The Bit datatype, according to my Sql book can
store true, false and null. So in the Defalut Value or Binding property
I attempted to put in True, but it would not accept it. I was however
able to put in the value 1 and it saved it as ((1)).
Anyhow my problem comes when I enter data in the table. I would fill in
a row and tab over to the next row. The result is a red circle with an
exclamation point and when the mouse hovers over that I get "This row
was successfully commited to the database. However, a problem occured
when attempting to retriece the data back after the commit. Bacause of
this, the displayed data in this row is read-only. To fix the problem,
please re-run the query." Also the default value of True was not
populated to the bit column.

So if I click on the Execute SQL button the red exclamation point goes
away from the record selector AND the bit field populates with True.

Any ideas of what I'm doing wrong to generate the warning/error?

Thanks,

very new newbe.

.

Quantcast