Home » Developer & Programmer » Forms » forms login info - urgent !!!!!!!
forms login info - urgent !!!!!!! [message #77688] Sun, 04 November 2001 17:34 Go to next message
satish
Messages: 112
Registered: September 2000
Senior Member
hi,
how do i insert values into a table(form_login_tab- created by me) which has fields login_user and login_time whenever any user opens any form in the application.

Please write to me asap

thanks
satish

----------------------------------------------------------------------
Re: forms login info - urgent !!!!!!! [message #77691 is a reply to message #77688] Sun, 04 November 2001 22:41 Go to previous message
Muhammed Shahzad
Messages: 10
Registered: November 2001
Junior Member
Use get_application_property(username)
in ur when-new-form-instance trigger or pre-form
trigger and insert it into ur table.

and for the time write this to get the time in ur pre-form trigger or when-new-form-instance trigger.

declare
vtime varchar2(10);
begin
select to_char(sysdate,'hhmiss') into vtime
from dual;
:global.vtime := vtime;
end;

----------------------------------------------------------------------
Previous Topic: Checkbox_checked
Next Topic: delete last n rows in a table..
Goto Forum:
  


Current Time: Sun May 31 19:17:54 CDT 2020