Nope. Just adding or updating a child which points to a parent. The FK field of the child is never changed, nor the PK of the parent. So I don't know how a FK constraint can be violated.
-----Original Message----- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of W O Sent: Thursday, October 04, 2012 6:35 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] violation of FOREIGN KEY constraint Are you using some managing program, like EMS SQL Manager? Sometimes it fails with errors as that you had posted. The solution is to close the program and start it again. Greetings. Walter. On Thu, Oct 4, 2012 at 10:13 AM, Rick Debay <rde...@accessrxs.com> wrote: > ** > > > Anyone? > > > -----Original Message----- > From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay > Sent: Wednesday, September 12, 2012 11:30 AM > To: firebird-support@yahoogroups.com > Subject: [firebird-support] violation of FOREIGN KEY constraint > > ISC ERROR CODE:335544345 > ISC ERROR MESSAGE: > lock conflict on no wait transaction > violation of FOREIGN KEY constraint "FK_RPLPO_REPLGRP" on table > "RPL_PO" > > The relationship between parent and child was always valid, so I don't > know why this error was raised. Can this occur if a column in the > parent row (other than the column referred to in the foreign key) was > modified? > > ------------------------------------ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item on the > main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links
