Hah! I figured it out.



select * from appointment

left join patient

on (appointment.patientid = patient.patientid)

where

patient.patientid is null



showed me where an appointment existed by the patient did not.



I deleted the appointment row and committed.



I was then able to reactivate the fk.



Thanks if you replied while I was writing this.



Dayna.









From: Dayna [mailto:quathiaski@...]
Sent: Saturday, July 07, 2012 09:10 PM
To: 'IBObjects@yahoogroups.com'
Subject: IB_4_7 Blob issues. Reply required urgently. Customer opens again
on monday.



Hi there. On a version 2.5.x firebird database.



My customers started getting a message 'BLOB NOT FOUND'.



So I gfixed the table and then did a backup/overwrite restore on it.



Now I'm getting a dozen messages about unable to activate index because :



gbak:cannot commit index FK_DIAGNOSISITEM_1

gbak: ERROR:violation of FOREIGN KEY constraint "FK_DIAGNOSISITEM_1" on
table "DIAGNOSISITEM"

gbak: ERROR: Foreign key reference target does not exist



yet I can open both the table where the FK is defined and in the target
table I can open and view the data.



How can I fix this without losing data if possible.



Dayna.







[Non-text portions of this message have been removed]