Subject Re: [ib-support] Re: Stored Procedure q (NewBie)
Author Lucas Franzen
> Yes You're right at the begining, my procedure was like your sentence
> UPDATE Cari Set Borc = BORC + :YOURVALUE where CariID = :CariID;
> but if the field borc have null value the result doesn't change again

Ups - you're right.

> I'll try to remove allow null property for the fields that I would
> make this kind of calculations.

Just add a before insert (maybe also update) trigger and set the value
to 0 if it is null.

> thanks for your interest..

you're welcome.