Hi All
Error is "org.firebirdsql.jdbc.FBSQLException: GDS Exception. index unexpectedly deleted"
jaybird JDBC Driver 1.0.1, FirebirdSQL 1.0.2


I recieve this error when I try to delete a row in a database
I have 2 tables - instruments and reminders
reminderis is one to many in relationship with instruments,
in other words it contains instrument_id which is foreign key constraint to instruments.id
lets say
INSTRUMENTS REMINDERS
-------------------- -------------------
(PK) ID---------------------\ (PK) ID
NAME ------------------< (FK) INSTRUMENT_ID
NAME
ONE-TO-MANY Relashionship
When FOREIGN KEY contraint is set ON DELETE CASCADE I got this error
when constraint is not set to do any particular action (IOW to restrict deleting)
it works like charm.
However I have used this ON DELETE CASCADE with many projects... so what is the problem?
I have already posted this message to jaybird group and I have been advised to ask here.

Niki

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