Thanks for your quick reply. I understand the concept of setting IsIdentity and have done this - the llblgen generated code is grabbing the next value for the primary key from the oracle sequence and using it when the new record is created.
I use a trigger like this so that llblgen can set the pk, but if I want to load records from oracle directly I can do so:
CREATE OR REPLACE TRIGGER PRR.PROJECT_PK_TIB
BEFORE INSERT
ON PRR.PROJECT REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
--Assign PK
IF (:new.project_id IS NULL) THEN
SELECT seq_project.NEXTVAL INTO
:NEW.project_id FROM DUAL;
END IF;
END;
/
However, what I need to do is to get the primary key for the "just inserted" record, so that I can redirect away from the form to show the "just inserted" record.