Bonnie;
Let me say that I understand what the error means and I am requesting suggestions about how to resolve it. I tried Google and did not find a solution.
Tom
>Tom,
>
>>>Any suggestions?<
>
>None other than to look at your data and see what's contained in the Foreign Key. The error message means just what it says ... you have a Foreign Key in the table you're trying to update that doesn't exist in the "parent" table.
>
>~~Bonnie
>
>
>>Windows 2000
>>SQL Server 2000 SP1
>>
>>Problem:
>>
>>Unable to update column that is a foreign key.
>>
>>Error:
>>
>>UPDATE statement conflict with COLUMN FOREIGN KEY constraint...
>>
>>Any suggestions?
>>
>>Thank you in advance.
>>
>>Tom
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement