We get the same error on our 3 tier app if I remove an index that is used
in the plan of a query, my theory is that these were prepared at startup or
on first use and not prepared again. We shutdown the db and restarted it
and there was no more problem.

-----Original Message-----
From: Almond [mailto:almond@...]
Sent: 11 March 2004 06:18
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Cascade delete

I try to delete a master record has about 200 slave record on 10 tables.
The operation cannot completed and return the following error message.

Statement failed, SQLCODE = -901

index unexpectedly deleted

Any body have information about this. All comments us welcome.

Best regards,

Almond Wong