CREATE TABLE "Incident"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"ProjectID" INTEGER NOT NULL,
"Description" VARCHAR(60) COLLATE "ANSI" NOT NULL,
. . . .
)

CREATE TRIGGER "InsertIncident" BEFORE INSERT ON "Incident"
BEGIN
  DECLARE TempCursor CURSOR FOR stmt;   
  DECLARE Result DECIMAL(20,2) DEFAULT 0;       

  PREPARE stmt FROM 'SELECT IFNULL(MAX(ID) THEN 0 ELSE MAX(ID)) AS MAXID FROM Incident
WHERE ProjectID = ?';
  OPEN TempCursor USING NEWROW.ProjectID;
  FETCH FIRST FROM TempCursor (MAXID) INTO Result;    
  SET NEWROW.ID = Result + 1;
  CLOSE TempCursor;
END