Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: 547 error: help decoding

    Can someone explain in more detail, or in plain english, what this error is trying to say.. ???

    "An SQL error occured - 547 error: INSERT conflicted with column Foreign Key constraint 'Employee_FK00'. The conflict occured in database NAME, table 'Union', column 'UnionName'. "

    I get this error aftering trying to add a new row in my .Net Winform i'm developing. Thanks!

  2. #2
    Join Date
    Feb 2004
    This might be because you are trying to inserting a detail record that expects a header record to exist in another table.

    For example, say you are trying to insert 'Union_1' into column in a table (employee?), but that table has a constraint where 'Union_1' MUST exist in table union in column unionname. If 'Union_1' does not exist in union, it is not going to allow you to insert it into the other table.

    BTW, Union is a keyword so I'd be careful with using it as a table name.

    Select * from a
    select * from b

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts