Subject RE: [firebird-support] Detect FK usage
Author Ann W. Harrison
At 07:12 PM 11/9/2004, Chad Z. Hower wrote:

>:: >But for edit - how can I determine easily if its already in use and
>:: >then decide to allow it to be updated or not?

>Only if it affects the keys. The edits would be on fields that are not part
>of the key. For exampel I have an Item table, its key is ItemID. It has a
>Name field - but I don't wat the user to be able to edit Name after ItemID
>is referenced from another table.

I'd write a trigger that checks for a reference and disallows updates
if one exists.