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 |
|
sqlWhat
Starting Member
12 Posts |
 Posted - 2006-10-11 : 10:41:13
|
| I have this application which takes data from templates and inserts them into the users account. But I made a mistake on the logic of the program and therefore messed up the data in the database under this demo account. I need to get rid of duplicated rows. But I keep getting this error and I am not sure why. This is the errorNo rows were deletedA problem occured attempting to delete row 3error source: ms.vs.dterror message: the row value(s) updates or deleted either do not make the row unique or they alter multiple rows(17 rows).correct the errors and attempt to delete the row again or press esc to canel the changes(s).tyhanks for the help in adbance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-11 : 10:43:19
|
| How are you trying to delete the rows.Sounds like this message is coming from an application.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sqlWhat
Starting Member
12 Posts |
Posted - 2006-10-11 : 11:11:27
|
| x002548I tried your link I am not sure what I need to do with it. Do I need to ask a question or search for the answer? I would appreciate a suggestion in fixing this proble. The rows are duplicate data and therefore causing havoc in the table or at least in this account. Thanks again for the help |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-11 : 11:26:24
|
| *EDIT* didnt read entire thread Where is this error coming from? A web application, or Query Analyzer, or where?[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
sqlWhat
Starting Member
12 Posts |
Posted - 2006-10-11 : 11:30:03
|
| I got the rows deleted. I created this delete statement to get rid of the rows. I was thinking that if you choose the row from the editor and delete it would be the same if you make a statement. THanks again for the help |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-11 : 13:29:05
|
| You tried to remove the rows from a resultset in QA?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
can not delete rows