This week's book giveaway is in the Design forum.
We're giving away four copies of Mastering Non-Functional Requirements and have Sameer Paradkar on-line!
See this thread for details.
Win a copy of Mastering Non-Functional Requirements this week in the Design forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Delete Command failed: No Unique row for the Matching Condition  RSS feed

 
Rajahari Kannan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys,

Yesterday i was creating a database in derby using netbeans ide. There was nearly 60 records in a table. By mistake after entering all data , i clicked the ok button 2-3 times and now there are nearly 180 records instead of 60 records. Is there any way to eliminate those unwanted records. i Cannot Delete Those Records which are unwanted.

Error Occurred : "Delete Command failed: No Unique row for the Matching Condition"

Please Help Me..

regards,
Rajahari Kannan
 
Maneesh Godbole
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it is your code which generates the records from scratch, I would say the easiest way is to delete the DB from the disk and start over again
 
Rajahari Kannan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Maneesh,

I was entering details manually using the netbeans ide. But its ok, i have started my work from first. Thanks for your help.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!