Subject Re: [ib-support] Interbase Transactions
Author Ali Gokcen
Post date 2000-12-15T08:35:10Z
Hi Svein,
i'm using  alot of before insert triggers without null control and there is no problem
&  I saw IB Server validation check procedure never calls this trigger if there is an error.
----- Original Message -----
Sent: Friday, December 15, 2000 10:26 AM
Subject: Re: [ib-support] Interbase Transactions

I believe this was a Before Insert trigger, which simply says that if no
value for IDFIELD has been generated, then generate one. So Helen's code is
just fine.

Set

At 10:11 15.12.2000 +0200, you wrote:
>>>>
>...
>   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 )

eGroups Sponsor 
<http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17000077
09:N/A=466331/?http://features.yahoo.com/webceleb/carrey/>Click Here! 

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



<<<<




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com