Home » Developer & Programmer » Forms » Multiple Session of forms
Multiple Session of forms [message #272707] Sat, 06 October 2007 08:14 Go to next message
nabeel_nab
Messages: 6
Registered: September 2007
Location: JEDDAH
Junior Member

Hi
i have one question ,i am using forms 6i,i want to control forms session.if one user is working on one form he sholud not allow to open the same form in same session.
if i plan to do it by writing code it will be a long exercise to have control over application consistes of more then 2000 forms.
is there any built in function avaialable in forms to check this .
Best Regards
Nabeel
Re: Multiple Session of forms [message #272720 is a reply to message #272707] Sat, 06 October 2007 09:34 Go to previous messageGo to next message
tiny_oracle
Messages: 20
Registered: October 2007
Location: Syria
Junior Member

Actually Nabeel I don't really know how to do it with Built-In , or I can't understand what you want .

But all what I know about form sessions that when using ( open_form ) built-in you can determine the parameter (SESSION or NO_SESSION) to control the session for the form .

Yours
Tiny_Oracle

[Updated on: Sat, 06 October 2007 09:38]

Report message to a moderator

Re: Multiple Session of forms [message #272728 is a reply to message #272707] Sat, 06 October 2007 12:27 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you are trying to maintain data integrity by not allowing users to run the same form twice during the session ... oh, my!
Re: Multiple Session of forms [message #272731 is a reply to message #272728] Sat, 06 October 2007 13:46 Go to previous messageGo to next message
nabeel_nab
Messages: 6
Registered: September 2007
Location: JEDDAH
Junior Member

Yes , i dont want user to run same form twice if he has same form already opened.
Thank you in advance .i am still looking for shortest way to control this .
Re: Multiple Session of forms [message #272735 is a reply to message #272731] Sat, 06 October 2007 16:20 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way might be creating a table
CREATE TABLE forms_log
(form_name  VARCHAR2(30),
 start_time DATE,
 end_time   DATE
)
and insert a record into it during the form startup (for example, using the WHEN-NEW-FORM-INSTANCE trigger) and, at the same time, checking whether this form already has a record with 'end_date IS NULL' (which would mean that it has not ended yet). Fill (i.e. UPDATE) the record upon the form exit (KEY-EXIT trigger might be one of them).

I doubt this approach is acceptable as you have ~2000 forms - you'd have to change all of them. Or, is there a way to do that differently? I wouldn't know.
Re: Multiple Session of forms [message #272886 is a reply to message #272731] Mon, 08 October 2007 02:17 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered only using 'new_form' instead of 'call_form' an 'open_form'. This way only one form is open at a time.

David
Previous Topic: How do I set global font (Type and Size) setting in forms?
Next Topic: I need help about running the form (merged & renamed by LF)
Goto Forum:
  


Current Time: Sun Dec 04 06:22:14 CST 2016

Total time taken to generate the page: 0.08043 seconds