Werner F. 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 call - It's amazing how easy it is to see what you expect rather than what
is actually written :)
Slight aside, but Flamerobin does do a nice job of creating this sort of stuff
when one is developing tables ... and then one tends to forget just what the
code is doing.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php