Version 4.2.6.00.03
Hello,
I have a wizard generated Tab Form and I have to populate two columns Last Updated By and Last Updated Date.
I'm having a horrible time doing something that should be fairly easy.
I created a page process:
BEGIN
FOR i IN 1 .. APEX_APPLICATION.g_f01.COUNT
LOOP
UPDATE high_level_estimate
SET last_updated_date = SYSDATE
,last_updated_by = :APP_USER
WHERE high_level_estimate_id = APEX_APPLICATION.g_f03(i);
END LOOP;
END;
But the columns are not updated.
The primary key column and the primary key display column are not being shown which is why I think the columns are not being updated.
So when a new row is added or an existing row is updated when the Submit button is clicked these two column need to be updated.
Can someone help me get this working?
What information can I provide?
Thanks,
Joe