Thursday, December 6, 2012

FORM CREATION IN ORACLE

 
>Open WINSCP


>Then go to Template.fmb,path is FORM>>US>>TEMPLATE.FMB.copy this .fmb file in your desktop.
>Now you can close the winscp
>Then open FORM BUILDER,Delete the already existing Module “MODULE1”.


>Then open Template.fmb in Form Builder And save it with any other name (ex:my_info).

>Then go to Data Block and Delete the “Block Name”.


>Now similarly, go to Canvases and Windows and delete the Block Name.


> Canvas contain designing of the form. Now, to Create a new canvases Click on Add.

 
> Now go to Property Palette give Name (ex: my_can) and then go to Property Class>>Subclass            Information>>canvas























>Then you need to close the window


> Follow the same procedure for windows. Create a new window


>Now give Name, Subclass Information and Primary Canvas name.


>Now again go to canvas set the window name whatever we have added


>Now close the window and go to Data Block and add a new data block


> Then click ok

> Then click on next

>Then click on next


Then click on browse you will get connect give in there user name&pwd....

>Now you will get tables name,select your table name here


Then select the table that you have created or the table that is to be used

 >   Then pull all the fields or only required fields.


>Then click on next

>Then again click on next

>Then click on next


 >Now click on finish


>Then click on next.



 >Then again click on next

 >Now pull all the fields 



>Now click on next again

 >Now here we can modify the width and height

>Then click on next


>Again click on next

 >Then give the Frame Title
>Then click on next


>Now click on finish


>Now we need to make the alignments based on our requirement


>Then add two buttons "save" and "exit"



>Now right click on the button and go to property palette

>Then after clicking on property palette give the Name, Subclass Information and Label
>   Similarly for Exit also.

>Now after giving values in property palette we will get


>Now press F11 by going on to the button 


>Now select “WHEN-BUTTON-PRESSED” 




>Click “WHEN-BUTTON-PRESSED”



>Then write the code in the PL/SQL Editor for both Save and Exit


>Then go to Program Units

No comments:

Post a Comment