Posted by Erland Sommarskog on 04/27/07 21:43

Brian (b.houghtby@eaglecrusher.com) writes:
> I get this error when I run it.
>
> Msg 547, Level 16, State 0, Line 1
> The UPDATE statement conflicted with the REFERENCE constraint
> "FK_GL_TransLine_IMA". The conflict occurred in database "iERP80_EAGLE",
> table "dbo.GL_TransLine", column 'GLL_ItemID'.
> The statement has been terminated.
>
> Strange thing .... If I change the 99l% to 99L% it updates 5 rows, with
> the lowercase l, I get the error.

So are there are any rows in GL_TransLine with values in the column
GLL_ItemID starting with 99l?

Could you post the CREATE TABLE statements for the two tables, including
the definition of primary and foreign keys?

--
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]