OraFAQ Forum: Forms » How to set form to check that modified last record and updated.

Home » Developer & Programmer » Forms » How to set form to check that modified last record and updated. (oracle forms 12c R4 database 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set form to check that modified last record and updated. [message #681071]

Wed, 10 June 2020 13:33

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 21:03:41 CST 2025