forms login info - urgent !!!!!!! [message #77688] |
Sun, 04 November 2001 17:34 |
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 |
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;
----------------------------------------------------------------------
|
|
|