mk_delphi wrote:

>Hi,
>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
>applications.
>
>
>

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.

TIA.

German.