1 Attachment(s)
Delete statement conflicted with COLUMN REFERENCE constraint
Hi Guys
I dunno how that happened, but when i try to delete 1 of my Accounts in the DB this error appears. :$:
I also recognized that the AID field and the CID field in dbo.Account and dbo.Character are write protected so I cant edit it...
I know in the past I can just mark it and hit DEL and the Account was deleted, but with this error it's impossible...
And when I try to laod my backup it's the same -_-
Any solutions for this :?:
EDIT: Attached Screenshot of problem. The descrpition of the problem is in english BTW.
Re: Delete statement conflicted with COLUMN REFERENCE constraint
you deleted a column? o.o
Re: Delete statement conflicted with COLUMN REFERENCE constraint
Hehe no^^
I dun think so cuz in my Backup it's the same Prob.
EDIT: Is the AID and CID Field in ur DB writable??
EDIT2: Found this on google
Error Message:
Quote:
Code:
DELETE statement conflicted with COLUMN REFERENCE constraint Constraint Name.
The conflict occurred in database Database Name, table Table Name, column Column Name.
The statement has been terminated.
Causes:
This error occurs if you are trying to delete a record from a table that has a PRIMARY KEY and the record being deleted is being referenced as a FOREIGN KEY in another table.
But how can I change this??
Re: Delete statement conflicted with COLUMN REFERENCE constraint
when u got a list of the column names, right click on the aid column and edit it
then check what key u need.
(No clue exactly how u do it)
1 Attachment(s)
Re: Delete statement conflicted with COLUMN REFERENCE constraint
Mhh well I checked the Settings of my db and it seems like if there is only a PRIMARY Key listed :$:
But how is that error possible, when it's impossible to have an FOREIGN Key .
Im rly confued right now. :grr:
BTW is the AID and the CID field in your db writable or not?