flashjobs wrote:

>
>
> Hello!
>
> I have a database in FirebirdSS-1.0.3.972-0

> when i tried to restore this database, i cannot restore, one foreign
> key violation error is coming, but the database is working perfectly
>
> i have identified that there is invalid data(ie. data not in
> BILLMASTER) in foreign key column(BILLNUMBER, BILLTYPE) of
> BILLITEMDETAILS.
>
>
> How these problems are coming?

Did you store any data before you defined the foreign key? Is there
anything specific or unusual about the records in BILLITEMDETAILS that
violate the key constraint? Can you reproduce an insert or a set of
operations that cause the constraint violation?

Regards,


Ann