Home » Developer & Programmer » Forms » forms login info - urgent !!!!!!!
forms login info - urgent !!!!!!! [message #77688] Sun, 04 November 2001 17:34 Go to next message
Messages: 112
Registered: September 2000
Senior Member
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


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.

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

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

Current Time: Mon Dec 06 19:01:48 CST 2021