| Unable to enter text [message #257082] |
Tue, 07 August 2007 09:43  |
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 #258951 is a reply to message #258769] |
Mon, 13 August 2007 19:34  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
