Subject | Re: [ib-support] Re: Stored Procedure q (NewBie) |
---|---|
Author | Lucas Franzen |
Post date | 2001-11-05T12:08:51Z |
> Yes You're right at the begining, my procedure was like your sentenceUps - you're right.
>
> UPDATE Cari Set Borc = BORC + :YOURVALUE where CariID = :CariID;
>
> but if the field borc have null value the result doesn't change again
> NULL
>Just add a before insert (maybe also update) trigger and set the value
> I'll try to remove allow null property for the fields that I would
> make this kind of calculations.
to 0 if it is null.
> thanks for your interest..you're welcome.
luc.