Monday, May 11, 2009

Oracle Forms Tips

In Oracle programming when you are designing a form and you want to set auto fit w.r.t canvas then copy this code in form level trigger named when-new-form-instance


code:= 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-10);