using bit values in VS 2005 database manager
Hi,
Here's my problem : I'm using the server explorer to manage my sdf database, some collumns are in bit format, when I put some data in it (using the manager), I got checkboxes (to put the value to 1 or 0 I figure). But if I don't edit the checkbox (meaning : if i don't put the checkbox to "check" value) the manager let the collumn value do DBNull. I guess I can check then uncheck the cell... but doing so on more than 10 collumns in 5 separate tables with at least 20 rows in each... I think you can figure out how long it takes.
Are you planning on updating this part?
thanks!
[609 byte] By [
Seta] at [2007-12-16]
Hi Neil,
Thanks for answering
Well, if I change a bit collumn's property allowNull to false, I simply cannot create a row provided I first check all the "non-null-allowed" collumns and uncheck them after all.
I may be wrong, but I don't think using checkboxes is a good idea for filling tables, but i'm not in charge of this product after all :)
Seta,
I understand what you're getting at now. Yes, it's a bit of a pain having to go and flip all those checkboxes. Our intent for the editing view is to let you see the content of your database and make a few changes here and there. I admit it's not particularly well-suited to lots of data manipulation.
I'll pass along your suggestion to the guys that own this UI so they can consider some tweaks in our next release.
Neil
