Subject Re: [firebird-support] Custom RI was Re: Possible bug with CHECK constraint
Author Geoff Worboys
> Theres any more eficient way to do that? the query takes a
> seconds before result. I solve my insert troubles in
> despachado but have a not liked delay deleting foreign records.

You probably should read this article by Claudio Valderrama
"Declarative referential integrity v/s triggers"

As for the speed issue; you may need to ensure you have
appropriate indexes on your data. EXISTS is the correct
and fastest way to do what you appear to want.

Geoff Worboys
Telesis Computing