Subject Re: Foreign key constraint violation
Author hfsnell
--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...>
wrote:
> OK, so do these import operations fail or otherwise get interrupted
> sometimes?
>
> And if your check fails - the db is not found to be "in god status",
> what do you do?
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>
Usually, when my customer called me and complained about a bad action
in my software. I checked my db and found this error. I viewed the log
file and found out a violated foreign key error when importing data
from xls file.
The error message implies that the constraint operated well. The thing
I don't know how the data could insert into the child table and it
still existed after the error had occured.