Home » Developer & Programmer » Forms » How to set form to check that modified last record and updated. (oracle forms 12c R4 database 12c)
How to set form to check that modified last record and updated. [message #681071] Wed, 10 June 2020 13:33 Go to next message
sarah1992
Messages: 5
Registered: June 2020
Junior Member
hi all,

i am using form 12c R4 and database 12c.

My question is, what is the codes to check who last modified, and last updated record?

please help me out

thanks a lot.
Re: How to set form to check that modified last record and updated. [message #681075 is a reply to message #681071] Thu, 11 June 2020 15:14 Go to previous message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Store that info into the table. A database trigger might help.

Suppose that table (you use in a form) looks like
create table emp
  (empno      number,
   ename      varchar2(20),
   --
   last_user  varchar2(20),
   last_date  date 
  );
Then the trigger looks like this:
create or replace trigger trg_biu_emp
  before insert or update on emp
  for each row
begin
  :new.last_user := user;
  :new.last_date := sysdate;
end;
/

[Updated on: Thu, 11 June 2020 15:14]

Report message to a moderator

Previous Topic: User Access on different Modules(forms)
Next Topic: form calls report and stuck on procedure
Goto Forum:
  


Current Time: Mon Sep 28 11:28:38 CDT 2020