Subject Re: [firebird-support] Pre-testing delete for referential integrity issues
Author Ann W. Harrison
Myles Wakeham wrote:
> ... rather than giving the user the ability to 'try' to delete the
> record and be told that they can't because of a violation of a
> referential integrity rule, I'd like to be more pro-active with this and
> only give them a delete option of the contact record has no related data
> that would stop a delete from occuring.

There is a risk with all the methods suggested that a concurrent
transaction could add a child record while you're doing your check
or even between your check and your delete.