ORACLE FORM IMPORTANT NOTES

• How to make the 3 text field and one push button ?
• You can just follow my steps to make beautiful custom form 

oracle form like a application which developed the form first we can open the form builder and go to canvas .

a canvas is basically a field area where items are situated on there such items like push button radio button,checks box,picture elements and so on.lets do the form where 3 text field and one push button to get result of two text field .when we put the value into two text field e.g like 10 or 30 then result pass to 3rd text field while button pressed result is gone to the 40.i hope you understanding properly. lets we do it.

notes:-the items are situated physically on canvas but logically into the block.

click canvas→go to plus sign to add new canvas 2

changed the name adding after double click on adding we get a frame (area)

⇓

yo see left side there is so many components

⇓

just go and drag and drop the 3 text fields ⇒same task for push button.now here are three text fields ⎕⎕⎕ and push button ⎕⇒add color to the frame just go to left see left side found below here is fill color click on highlighting canvas area then add,then we can changed the name of text item while click two times .here is open a window called as properties palate here we can set the components .

notes:-here so many categories such as general,functional,font,color,prompt etc.

⇓

changed the name(if we clicked on components text items where properties open to change the name)

• that is similar for two others text fields. do both window minimize to understanding purpose.
• that is similar for push button 
• minimize the general properties we go to the functional here we changed the click me on label.
• go to the form we saw data block automatically created a new new block 3 here we can changed the name such as meaningful name e.g add.here we saw the data block have items below. 

finally we can see the items are below the data block such as num1,num2,res and result.
notes:-when do some task on canvas automatically item are added in data block.just click on plus sign⇒result⇒we get a trigger window here we can add trigger events .here we can add events such as when button pressed result will go to the res text field.here you can see the e.g
when button pressed↴
:add.res:=:add.num1.+:add.num2;
here add is data block,res is item(compiled the pl/sql code) here trigger will be successfully completed then save the form on Dextop (here form name adding) where extension is .fmb.
notes:-

• when we compile the file we get the executable file same will adding or extension is .fmx
• that is the file will run on server where client browser name the file or address the file name
• the location client browser automatically provides a path or name.
• here we go to the file and connect to the data base then click on run button↑(above option)

here we can add code again for replacing null value.(nvl is function that replace null value into the actual values.
⇓ 
:add.res:=nvl(:add.num1,0)+nvl(:add.num2,0);
then run again we will get the form where we can put any values to the items .its provided sum of two items.