Subject Re: [firebird-support] Re: foreign keys ans slow insert
Author German Pablo Gentile
mk_delphi wrote:

>why not migrate FK to a couple of triggers?
>in the beforeinsert of the main table you can
>check for Foreign record, in the beforedelete of
>foreign table you can check if the key is in the
>main table, but note this is subject to transactions
>status. I think this is better then put checks inside
It make sense depending what mind *better* for every case. in my case,
better is compatibility with others DB with minimal effort.
Using Asta , IMHO and in that app theres no great advantages in using
triggers in place of Delphi.