> Glad to help. This example, however, raises an intersting
> question for me. I could try it to find out but, could this
> test be restructured as:
>
> IF (COALESCE(new.AC_ID, 0) < 1) then
> new.AC_ID = Gen_ID(GEN_AC_NEW_ID, 1);
>
> ??
>
> Woody (TMW)
>

New test done.

As I expected the problem is in my code.

Once more thank you

daniel
____________________________
Comvision Pty. Ltd.

www.comvision.net.au