Posted by Erland Sommarskog on 04/25/07 21:44

Brian (b.houghtby@eaglecrusher.com) writes:
> I must be doing something wrong, this is my error.
>
> Msg 547, Level 16, State 0, Line 3
> The UPDATE statement conflicted with the REFERENCE constraint
> "FK_GL_TrnsLne_IMA". The conflict occurred in database "EAGLE", table
> "dbo.GL_TrnsLne", column 'GLL_ItmID'.
> The statement has been terminated.

One problem is that we don't know what you are doing. First you ask how
to do something, then you present an error message. That means that we
have to guess.

If you change 99l5555 to 99L5555 and this gives the error above, this
indicates two things:
1) This is a key value, and there are other table referencing that key
value.
2) The database uses case-sensitive or binary collation.

There are a couple of ways to go. One is to change the constraints
to have ON UPDATE CASCADE.

But it would help to know more about what you are trying to achieve.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]