| Oracle Forms exit_form twice [message #659566] |
Sun, 22 January 2017 12:09  |
 |
IneedYourHelp
Messages: 27
Registered: January 2017
|
Junior Member |
|
|
Hi,
i am totally new to PL/SQL and FORMS. I know this question was already asked, but the answers I could find didnt help me, because i am still a beginner.
I want to open a new form with new_form('C:...'); as a button pressed trigger, but i get the error: frm-40202 Field must be entered.
When I enter one part of a record it works. The answer to the similar question let me guess that it is because the form is in some kind of insert mode.
Thats why you need to use exit_form twice to really exit it.
In my case I think that I would need to use exit_form and than open_form, but the problem ist that I basically don't know any syntax of PL/SQL stuff.
exit_form(What does belong here?);
new_form('C: ...');
does not seem to work.
To similar answers there were explanations but no script, which did not help me as a beginner.
Thanks.
|
|
|
|
| Re: Oracle Forms exit_form twice [message #659567 is a reply to message #659566] |
Sun, 22 January 2017 15:14  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
In order NOT to guess valid syntax, while in Forms Builder, click the "Help" menu and open online help system. It allows you to search, so - when in doubt - check the correct syntax. Moreover, Help contains numerous examples.
As of what you currently are doing, I doubt that double EXIT_FORM solves any problem (EXIT_FORM, as its name says, exits the form Its keyboard shortcut will also exit query mode, but I can't remember any situation which requires TWO calls). "Field must be entered" probably means that there's at least one item which has its "Required" property set to "Yes", so you can't navigate out of that form until you enter all required values. It means that you should rethink the process as you probably want to enter current record's values and then navigate to another form.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
