At 10:43 PM 10/04/2007, you wrote:

>hi all, i have this project to build a crm application. my sales order
>table has a foreign key referenced to the customer table. my problem
>is that, everytime i try to delete a customer record, i got this
>"foreign key" exception. how do i know that this customer record is
>not referenced to the sales order record before the user press the
>delete button?
>
>i use firebird 2 and delphi 7
>
>any comments will be highly appreciated

Catch the exception, report the problem to the user and then cancel
the operation. Delphi is very good at handling exceptions and this
is by far the most efficient way to do it.

./heLen