Home » Developer & Programmer » Forms » Unable to enter text
Unable to enter text [message #257082] Tue, 07 August 2007 09:43 Go to next message
jlharvey
Messages: 2
Registered: August 2007
Junior Member
Okay - this is the situation.

I have one form open (FORM1) and I navigate to a second form (FORM2)using a navigation frame (so the 1st form is still open). I then navigate back to the first form (FORM1) using the navigation frame of the new form (FORM2) (so now I have the same form open twice in the same session.) The form opens the 2nd time in Query mode since it was called from another form. I do Clear Form and try to enter a new record but I am unable to type in the field.

This only happens when I have it open twice. For example if I open FORM2, navigate to FORM1 using the navigation frame and do Clear Form I am still able to enter data into the fields. The problem only happens when I have the form open twice in the session.

Does anybody know what could be causing this problem?

Thanks in advance.
Re: Unable to enter text [message #257286 is a reply to message #257082] Wed, 08 August 2007 00:35 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you use 'session' or the default 'no_session' in your 'open_form' from Forms1 to Form2?

David
Re: Unable to enter text [message #258769 is a reply to message #257286] Mon, 13 August 2007 09:54 Go to previous messageGo to next message
jlharvey
Messages: 2
Registered: August 2007
Junior Member
The default 'no_session'.
Re: Unable to enter text [message #258951 is a reply to message #258769] Mon, 13 August 2007 19:34 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The documentation states that:
Quote:
NO_SESSION (The default.) Specifies that the opened form should share the same database session as the current form. POST and COMMIT operations in any form will cause posting, validation, and commit processing to occur for all forms running in the same session.

Think about what you are trying to get Oracle to do. By starting Form1, opening Form2, and then opening ANOTHER copy of Form1 ALL IN THE SAME SESSION you will be most likely trying to update the same record in TWO places. Oracle really doesn't like this. It is possible that if we searched the Oracle documentation well enough we would find something that says that the same form opened in the same session will be opened in query only mode. This is something similar to the reference manual entry:
Quote:
If the form that issues the OPEN_FORM built-in is running in QUERY_ONLY mode, then the opened form will also run in QUERY_ONLY mode.

David
Previous Topic: create trigger on table at runtime
Next Topic: how to highlight......
Goto Forum:
  


Current Time: Thu Dec 08 10:48:27 CST 2016

Total time taken to generate the page: 0.09961 seconds