At 16:31 09/04/02 +0530, you wrote:

>On Tue, 9 Apr 2002, Nick Upson wrote:
>
>Hi
>
>Just created and tried a trigger in drug_bill. The following is the body
>of the trigger
>
>BEGIN
>
>delete drug_bill_item where drug_bill_item.bill_id=bill_id;

^
|
I notice a "bug" here ----------------------------------|

should be something like this:

delete drug_bill_item where drug_bill_item.bill_id = old.bill_id;



HTH

Alexandre