Creating a Simple Model - Item Master

  1. Description of DataObject :

    DataObject Name : ItemMaster
    Table Name : item_master
    Group Name : General
    Column Name : item_code - Varchar(20) - Primary Key
    item_description - Varchar(40)
    uom - Varchar(20)
    Group Name : Purchase
    Column Name : prefered_vendor - Varchar(20)
    item_rate - Double
    remarks - Varchar(40)

  2. Model Factory :

    Step 1:

    Click new button, Enter ItemMasters as DataObject Name.

    Note : Click right mouse button , select Properties from the Popup menu and have a look.

    Step 2:

    Enter item_master as table name , set cardinality as OnetoOne and Parent as None.

    Note : Click right mouse button , select Properties from the Popup menu and have a look.

    Step 3:

    Enter General as Group Name

    Step 4:

    From generic tree node of objectrepository tree, drag and drop columns to dataobject tree.

    1. varchar - Enter column name as item_code , check the key checkbox and enter width as 20.

      Note : Click right mouse button , select Properties from the Popup menu and have a look.

    2. varchar - Enter column name as item_description and width as 40. Open Column Property sheet and set value for property summary as yes.

      Expand MetaModel, Masters tree node In objectrepository tree, drag and drop columns to dataobject tree.

    3. UOM - Enter Column name as UOM , width as 10 and Open Column Property sheet and set value for property summary as yes.

    Step 5:

    Click Add Group button in floating toolbar Enter Purchase as Group Name

    Step 6:

    From generic tree node of object repository tree, drag and drop columns to dataobject tree.

    1. varchar - Enter column name as prefered_vendor and width as 20. Open Column Property sheet and set value for property summary as yes.
    2. Double - Enter column name as item_rate, Open Column Property sheet and set value for property summary as yes.
    3. varchar - Enter column name as remarks and width as 40. Open Column Property sheet and set value for property summary as yes.

    Step 7:

    Click save button, check Table , Sql , checkbox along with defaults and Click Ok button.

    Step 8 :

    Click Create button to create table in Database.

    Model Created Successfully.

    Model FAQ.

    Step 9:

    Click FormFactory button in the ToolBar

    Step 10:

    Click objecttree button in toolbar or statusbar

    Step 11:

    Click Swing Preview button in the Object Tree toolbar.

    Step 12:

    Close the Swing Preview

    Step 13:

    Click HTML preview in object Tree toolbar.

    ( Note : If you encounter any problem in openning the HTML file from FormFactory then open the file in \applesetutor\html\item_master_ns or \applesetutor\html\item_master_ie. )

    Step 14 :

    Click Save button in the ToolBar.

    Step 15:

    Click compile button to compile the created java file.

    ( Note : If you encounter any problem in compiling your DataObject in FormFactory then switch to Command prompt and Execute the citemmaster.bat file in \AppleseTutor\Src folder to Compile the java file.

    Step 16 :

    Execute the RItemMaster.bat file in \AppleseTuotor\Src folder to Run the Class file.

    Form Created Successfully.

    Check List :

    1. ItemMaster.xml - XML
    2. ItemMaster.dml - DML
    3. ItemMaster.dml - Summary
    4. ItemMaster.sql - Sql
    5. ItemMaster_index.htm - HTML
    6. ItemMaster_ns.htm - HTML
    7. ItemMaster_ie.htm - HTML
    8. Item_masteritem_code.htm - HTML
    9. ItemMasterEvent.xml - Event
    10. ItemMasterSchemaEvent.xml - Event
    11. ItemMasterEvent.java - Event
    12. SchemaItemMaster.java - Src
    13. ItemMaster.class - Src
    14. SchemaItemMaster.class - Src
    15. citemmaster.bat - Src
    16. ritemmaster.bat - Src