Results 1 to 3 of 3
Thread: Cant delete data in sql database
LinkBack URL
About LinkBacks- 12-16-2012, 09:38 AM #1
Member
- Join Date
- Dec 2012
- Posts
- 4
- Rep Power
- 0
Cant delete data in sql database
Cannot delete or update a parent row ; a foreign key constraint fails
is there some kind of option i need to disable?
- 12-16-2012, 01:13 PM #2
Moderator
- Join Date
- Sep 2008
- Location
- Madgaon, Goa, India
- Posts
- 9,937
- Rep Power
- 16
Re: Cant delete data in sql database
Moved from Advanced Java, although this appears to be a database rather than a JDBC question.
dbWhy do they call it rush hour when nothing moves? - Robin Williams
- 12-17-2012, 10:29 AM #3
Moderator
- Join Date
- Apr 2009
- Posts
- 10,481
- Rep Power
- 16
Re: Cant delete data in sql database
No, what you need to do is sort out your database.
If deleting violates a foreign key, then the usual solution is to delete the dependent rows as well, since they are now no longer valid.Please do not ask for code as refusal often offends.
Reply With QuoteSimilar Threads
-
create,edit ,delete in JSP usin struts and SQL server as database in jdeveloper
By gurpreet.singh in forum JavaServer Pages (JSP) and JSTLReplies: 1Last Post: 03-11-2011, 12:43 PM -
Delete and edit data in xml file using JSP
By gurpreet.singh in forum JavaServer Pages (JSP) and JSTLReplies: 6Last Post: 03-10-2011, 08:07 AM -
How to store data from textfile to vector and delete a selected row.
By nemesis in forum New To JavaReplies: 15Last Post: 11-13-2009, 11:00 AM -
Not able to delete MSSql database table entries
By wickedrahul9 in forum Advanced JavaReplies: 3Last Post: 10-17-2008, 12:14 PM -
How to Modify,Delete data in File Txt???
By hungleon88 in forum Advanced JavaReplies: 9Last Post: 09-24-2008, 03:19 AM
Bookmarks