OraFAQ Forum: Forms » can i make the table in the database that i open my application i insert the record it

Home » Developer & Programmer » Forms » can i make the table in the database that i open my application i insert the record it

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

can i make the table in the database that i open my application i insert the record it [message #147612]

Fri, 18 November 2005 09:34

ashraf_arif59
Messages: 35
Registered: March 2005
Location: Pakistan

Member

can i make the table in the database that when i open my application i insert the record it
and when i close the application the insert record should be deleted

there are many possibility of closing the application
mean electricity fault,
close application abnormally

plz tell how i delete the related record;

Report message to a moderator

Re: can i make the table in the database that i open my application i insert the record it [message #149774 is a reply to message #147612]

Sun, 04 December 2005 22:53

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I suggest that you create a package containing a few procedures or functions. One procedure would create an entry in your 'user_info' table that says that you have started work. This procedure would be called in your When-New-Form-Instance trigger. It could test to see if there is already an entry in the 'user_info' table for this user and if so cause an alert to appear saying 'you failed to logoff properly' (or whatever). In your exit_form trigger you could call another procedure in the package and use it to either 'delete' the record from the 'user_info' table or change a 'session_status' to 'null'.

David

Report message to a moderator

Previous Topic:	getting sysdate on a field
Next Topic:	Go Block on forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:01:03 CDT 2024