Thank You for your help Neil and Spencer.
I have implemented what you suggested and the problem also has resolved by
by changing some system settings.
"Neil" <neil_at_nospam.com> wrote in message news:<sgKu7.30044$qi.3890053_at_news2-win.server.ntlworld.com>...
> Mohnish
>
> > CREATE OR REPLACE TRIGGER "WWW".TRIGELEC_HIS_INSERT BEFORE
> > INSERT ON "WWW"."TBLELEC" REFERENCING OLD AS o NEW AS n
> > FOR EACH ROW
> > WHEN (n.ELEC_HIS_ID = 0 OR n.ELEC_HIS_ID = NULL)
>
> Should be:
> WHEN (n.ELEC_HIS_ID = 0 OR n.ELEC_HIS_ID IS NULL)
>
> X = NULL is always false
>
> Neil
Received on Fri Oct 05 2001 - 10:31:29 CDT
