Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tvspsekhar
Starting Member
20 Posts |
 Posted - 2010-03-19 : 03:51:40
|
| Please help in solving the following probleml have created a small table with 3 columns without any constraints.I am entering the data in design view. ie in open table command and then entering the data. after some time I am not able to delete 2 rows were, which were entered wrongly or even to edit the same.I am getiing the followeing error message" the data in row 10 was not committed.error source:microsoft.visual studio.datatoolserror messag: the row value(s)updated or deleted either do not makethe row unique or they alter multiple rows(2 rows)correct the errors and retry or press ESC to cancel the changes.THE FOLLOWING ARE THE 2 ROWS TO BE DELETED. tHE SPAN COLUMN WAS OF INTEGER TYPE.LOCNO TWRTYPE SPANNULL A+0 NULLNULL A+0 NULLPlwease help me out. I had so much of the data in that table.I am not able to retrieve those 2 rows using select command also with where clause.tvspsekhar |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-03-19 : 07:10:07
|
| if you are not able to retrieve those rows in table then it means rows are not there in the table.Vaibhav T |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-19 : 11:20:04
|
| are you trying to do them through design view? is this happening when trying using query as well?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
byrdzeye
Starting Member
14 Posts |
Posted - 2010-03-24 : 15:44:48
|
| Add an identity field and the problem goes away.You need SOMETHING that makes a record unique and these records are identical.As is, you could use query to delete both or update both but not individually.As you have seen, you can do nothing with them using the visual tools without adding an identity column. (Identity because it needs auto populated and its the easiest way.) |
|
|
|
|
|
|
2 rows not getting deleted