At 12:35 18/10/01 +0000, you wrote:

>In this case, I do not want to allow user to delete record if child
>record is present. That is why I have kept default. But when my
>Delphi Application tries to delete Parent record, it shows an
>exception and then my application either hangs OR behaves abnormally.
>
>Now I do not know whether this problem is due to Delphi( I mean IB
>Connection components I am using) OR due to Firbird.
>
>and how to solve it ? please guide me ...

I use IB/FB with php and java, and don't know Delphi.
I don't think it comes from IB/FB.

PS : what about catching exception and showing a screen "impossible to
delete parent because of childs" ?

Paul