-
Copyrights 2010 - Online Training Oracle Applications. All Rights Reserved.
|
Create the hospital table in the database.
Now, let’s create the form using the above table. Open the form builder tool Tools Datablock wizard Next Table or View Table or view – Enter hospital Refresh provide connection details Move all the columns to database items Next Data block Name – HOSPITAL Next create data block, then call layout wizard Finish Welcome to layout wizard Next Canvas new canvas type – content Move all columns from available to displayed items Next next Select form Next Frame Title – Hospital details Next Finish File Save as in MY_FORMS folder HOSPITAL.fmb Program Compile module Pat ID – 101 Click on Save. We get error FRM- 40508: ORACLE error: unable to INSER record. To see the database error
As we have defined check constraint in the column Fee ( Fee >= 1000). Using Views Example SQL> select * from dept_analysis; We get the following output Let’s build the form using dept_analysis. Open the form builder tool Welcome to Layout wizard Next Canvas – New canvas Next Move all items from available items Displayed Items Next Next Form Next Frame Title – Dept Info Next Finish File Save as DEPT_ANALYSIS.fmb Program Compile Module Program Run Form ( Ctrl + R ) Click on Execute queryThe above form does not support DML operations, as the view is complex view.
|