On 09/26/2012 09:42 AM, SUNDAY A. OLUTAYO wrote:
> Dear all,
>
> I have issue with the red portion function below;
>
> This IF last_id IS NULL THEN suppose to test if last_id is NULL, that is
> the select query did not found it
> then execute the rest of the red sql but it always fail to insert the
> *NEW.amount *into*amount*, every other things fine.
Is there a NEW.amount?
>
> Kindly help out.
>
>
>
>
> Thanks,
>
> Sunday Olutayo
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com