際際滷

際際滷Share a Scribd company logo
Dr. Girija Narasimhan
Global Variable using call form path
PART 35
CLOSE_FORM RESTRICTION
OPEN_FORM
NEW_FORM
Dr. Girija Narasimhan
CLOSE_FORM RESTRICTION
You cannot close a form that is currently disabled as a result of
having issued CALL_FORM to invoke a modal called form.
You cannot close a form that has called you. For example, if
Form_A calls Form_B, then Form_B cannot close Form_A
If Supplier Form (calling form) and product (Called form)
Dr. Girija Narasimhan
When a form executes NEW_FORM to
invoke another form, Oracle Forms exits the
first form and releases its memory, and then
loads the new form (i.e., the second form
completely replaces the first. If changes are
pending in the first form, Oracle Forms will
prompt the end user to save them before the
new form is loaded.
NEW_FORM
Dr. Girija Narasimhan
Global Variable using call form path
Step 1: create data block supplier and when_new_form_instance
trigger->declare global variable as :global.call:=E:tutorial
Dr. Girija Narasimhan
Step 2: create three buttons new_form_product , open_form_product,
exit_form_supplier
Dr. Girija Narasimhan
Step 3: write below trigger coding in all three buttons
Step 4: create product.fmb and product data block and write
when_new_form_instance execute_query
Step 5: create two push buttons open_form supplier and exit_form

More Related Content

Part 35 close form,open-form,new_form

  • 1. Dr. Girija Narasimhan Global Variable using call form path PART 35 CLOSE_FORM RESTRICTION OPEN_FORM NEW_FORM
  • 2. Dr. Girija Narasimhan CLOSE_FORM RESTRICTION You cannot close a form that is currently disabled as a result of having issued CALL_FORM to invoke a modal called form. You cannot close a form that has called you. For example, if Form_A calls Form_B, then Form_B cannot close Form_A If Supplier Form (calling form) and product (Called form)
  • 3. Dr. Girija Narasimhan When a form executes NEW_FORM to invoke another form, Oracle Forms exits the first form and releases its memory, and then loads the new form (i.e., the second form completely replaces the first. If changes are pending in the first form, Oracle Forms will prompt the end user to save them before the new form is loaded. NEW_FORM
  • 4. Dr. Girija Narasimhan Global Variable using call form path Step 1: create data block supplier and when_new_form_instance trigger->declare global variable as :global.call:=E:tutorial
  • 5. Dr. Girija Narasimhan Step 2: create three buttons new_form_product , open_form_product, exit_form_supplier
  • 6. Dr. Girija Narasimhan Step 3: write below trigger coding in all three buttons
  • 7. Step 4: create product.fmb and product data block and write when_new_form_instance execute_query
  • 8. Step 5: create two push buttons open_form supplier and exit_form