On Fri, Jun 3, 2011 at 4:04 AM, Werner F. Bruhin <werner.bruhin@...> wrote:

>>    IF (NEW.ID IS NULL) THEN
>>      NEW.ID = GEN_ID(GEN_CUSTOMERINCIDENTS_ID,0);
> Shouldn't that be:
>
> NEW.ID = GEN_ID(GEN_CUSTOMERINCIDENTS_ID,1);
>

Good catch - that code would run forever without ever succeeding
in inserting a row. Fail, retry, same error, fail, retry ...

Cheers,

Ann