Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Reface Oracle Forms with a Modern UI Solution

User_KCUS4Feb 14 2022

Hello,
I was wondering how to reface Oracle Forms & Reports solution with a modern UI solution, where the Forms are used as a backend, and the front-end layer is the modern solution - e.g. Angular/Oracle Jet, Oracle APEX, etc.
Additionally, is there is a way to use AngularJS to completely delegate the Forms embedded business logic without needing to rewrite Forms business logic/triggers/errors from scratch?
Thank you,
Ahmad

Comments

Andreas Weiden

Check the online-help for SET_WINDOW_PROPERTY. There is also an option NORMAL for window-state.

Poor-Boy

I chose second option but when i try to close my window ... nothing hapend

My close Allowed option is Yes... & Also Held My Window

window.png

SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);

SET_WINDOW_PROPERTY('MAIN_WINDOW', X_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WIDTH ) - GET_WINDOW_PROPERTY('MAIN_WINDOW', WIDTH )) / 2);

SET_WINDOW_PROPERTY('MAIN_WINDOW', Y_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, HEIGHT) - GET_WINDOW_PROPERTY('MAIN_WINDOW', HEIGHT)) / 2);

Andreas Weiden

You have to put the logic you want to do when closing in a WHEN-WINDOW-CLOSED-trigger.

Poor-Boy

i just want to show run time window1.... i dont want to show the formd_mdi_window... can u tell me how can i hide this?

Poor-Boy

i need this size for both windows .... in center and small

0oooooo.png

Poor-Boy

like this small and in centre .. i want like this window

0oooooo.png

Hi

u have to adjust ur canvas size and ur formd_mdi_window will be adjusted accordingly.

u r the only one who can adjust the window size & canvas size it will be adjust by several tries. There is no matrix for this we can follow to give u a pre-defined one.

u can adjust it through the canvas layout or from their properties.


Amatu Allah.

Manu.
Answer

Dear,

Write the code in the WHEN-NEW-FORM-INSTANCE trigger of the form.

SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);

SET_WINDOW_PROPERTY('window1', X_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WIDTH ) - GET_WINDOW_PROPERTY('window1', WIDTH )) / 2);

SET_WINDOW_PROPERTY('window1', Y_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, HEIGHT) - GET_WINDOW_PROPERTY('window1', HEIGHT)) / 2);

We can't hide the FORMS_MDI_WINDOW, as this window is acting as the master window for the form application.

Manu.

Marked as Answer by Poor-Boy · Sep 27 2020
Poor-Boy

it's fine but when i call this form from other form with when_Button_press this query... This form open with full window

Manu.

Dear,

This is because of the calling form. The calling form will be in MAXIMIZED mode. So change the Maximized Allowed property of the WINDOW1 to NO. Then it will be OK.

Hope this helps.

Manu.

Amatu Allah Neveen Ebrahim

Yes follow Manu's comment it will work.

Amatu Allah.

Poor-Boy

Call_form('E:\Accounts\Forms\Assets.fmx',no_hide,do_replace,no_query_Only,'null');

This is my form calling query i just window property option no .... in Calling form property

but still getting problem see in backend of form

kalsai.png

Hi

Pls check any old trigger form level maximizing ur back window with other name.

Check the window name u maximize or close with the logic u expect.

Remove any unnecessary trigger.

Amatu Allah.

1 - 15

Post Details

Added on Feb 14 2022
3 comments
1,323 views