This content has been marked as final. Show 5 replies
I always leave my WEBUTIL database block as the last block like you are doing. Is the WEBUTIL block coming into focus when the user executes the form?1 person found this helpful
If it is then Open the Property Palette for your form module - the very first node in the Object Navigator tree. There should be a "First Navigation Data Block" field - set that to the database block that you want to navigate to when the user executes the form module or in the Form-level Triggers create a WHEN-NEW-FORM-INSTANCE trigger (you probably already have one set up) and at the bottom of it put in logic like GO_ITEM('BLOCK_NAME.ITEM_NAME'); to reference the item that you want to start the user out it. Either of these two methods should keep the WEBUTIL database block from coming into focus.
Oracle Forms is Heirarchical. It uses the order in which items appear in the Object Navigator as the "Default" navigation order. Items like WebUtil should always appear after other objects (such as Data Blocks, Canvases and Windows). Making sure objects are listed in the right order in the Object Navigator is typically all you need to do, however, you could use the Form Module First Navigation Data Block property to override the default heirarchy (as MLBrown suggests) as well as write code in a When-New-Form-Instance trigger to Hide the WebUtil canvases and direct the form to the desired starting point (first navigation block/item).
I personally, prefer to use the order of objects in the Object Navigator since this does not require any lines of code or the setting of properties.
On a side note, it is always good to post your Forms version (eg: 10.1.2.0.2 versus 10g) when posting a Forms question. :)
Thanks for your input, i will make sure to check what you say out tomorrow when i go to the office.
i managed to get a 'stupid' workaround, and that was to copy the code from the 'OK' button on the webutil canvas, and have it run on the form trigger 'when-new-window' or something like that, dont remember of hand. that did the trick but i will make sure to try what you say and change the code to reflect the changes you suggest.
Thanks for the information,
Edited by: 973733 on 28-Nov-2012 12:59
Hi ML Brown,
i have tried a go_item in the when-new form instance but did not work for my scenario. maybe of the 'complexity' of the form i was trying to alter, and as i said, im not ver familiar with forms. nevertheless thanks for the info. i will make sure i will try it out again tomorrow.
just tried altering (it was set to <Null>) the First Navigation Block in the form's properties to a soecific block and it works fine !!!
Thank you both for your help !