Subject Re: [ib-support] Interbase Transactions
Author Ali Gokcen
Post date 2000-12-15T08:11:15Z
>...
>   IF ((NEW.IDFIELD IS NULL) OR (NEW.IDFIELD=0))
THEN
>     NEW.IDFIELD = GEN_ID(THEGENERATOR,
1);
>...
>
> Helen

Helen,
a field needs a generator will be unique, unique fields can't be null or duplicate
so  that,
 if the field is null
     then this trigger never called. ( becouse cant pass the validation check )
 else 
     'NEW.IDFIELD IS NULL'  control is an garbage command and make busy our  IB  uh?  
       ( and inc. our code of course too )
 
am i wrong ?  ( sorry about my ugly english )