Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\TDPAX\td_bldaddrf.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Adding an Employees Report and Form</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:17:39Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Adding an Employees Report and Form" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11946-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="build_app.htm" title="Building Your Application" type="text/html" /> <link rel="up" href="td_bldaddrf.htm" title="Adding an Employees Report ..." type="text/html" /> <link rel="prev" href="td_blddptrprt.htm" title="Previous" type="text/html" /> <link rel="next" href="td_bldedit.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="build_app.htm" title="Building Your Application">Building Your Application</a> > Adding an Employees Report ...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="td_blddptrprt.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="td_bldedit.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCECFAJF" name="BCECFAJF"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="TDPAX04005|how to add an Employees report and form"></a>Adding an Employees <a id="sthref178" name="sthref178"></a><a id="sthref179" name="sthref179"></a><a id="sthref180" name="sthref180"></a><a id="sthref181" name="sthref181"></a>Report and Form</h1> <p>In this exercise, you add a report to display employee information and a form to create, update, and delete employee information.</p> <p>To add an employee report and form:</p> <ol> <li> <p>Click the <a id="sthref182" name="sthref182"></a><span class="bold">Application</span> link on the Developer toolbar (at the bottom of the page).</p> <p>The Application home page appears.</p> </li> <li> <p>Click <span class="bold">Create Page</span>.</p> </li> <li> <p>For Page:</p> <ol> <li> <p>Select <span class="bold">Form</span> and click <span class="bold">Next</span>.</p> </li> <li> <p>Select <span class="bold">Form on a Table with Report</span>.</p> <p>This option creates two pages, a report and form, based on a single table or view.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Identify Table or View:</p> <ol> <li> <p>For Table/View Owner, accept the default and click <span class="bold">Next</span>. This specifies the schema owner.</p> </li> <li> <p>For Table/View Name, select <span class="bold">OEHR_EMPLOYEES</span> and click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Define Report Page, make these changes:</p> <ol> <li> <p>Implementation - Select <span class="bold">Classic</span>.</p> </li> <li> <p>Page Name - Change to <code>Employees</code>.</p> </li> <li> <p>Region Title - Change to <code>Employees</code>.</p> </li> <li> <p><a id="sthref183" name="sthref183"></a><a id="sthref184" name="sthref184"></a><a id="sthref185" name="sthref185"></a>Breadcrumb - Select <span class="bold">Breadcrumb</span>.</p> <p>The Create Breadcrumb Entry section appears.</p> </li> <li> <p>For Select Parent Entry, click the <span class="bold">Home</span> link.</p> <p>Home appears in the Parent Entry field.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Define Report Page, accept the default, <span class="bold">Do not use tabs</span>, and click <span class="bold">Next</span>.</p> </li> <li> <p>For Define Report Page, press the <span class="bold">Ctrl</span> key, select the following columns, and click <span class="bold">Next</span>:</p> <ul> <li> <p>EMPLOYEE_ID</p> </li> <li> <p>FIRST_NAME</p> </li> <li> <p>LAST_NAME</p> </li> <li> <p>HIRE_DATE</p> </li> <li> <p>SALARY</p> </li> <li> <p>COMMISSION_PCT</p> </li> </ul> <p>The columns you selected appear on the Report page.</p> </li> <li> <p>For Define Report Page, accept the defaults and click <span class="bold">Next</span>.</p> <p>Note that the default Edit Link image resembles a small piece of paper and pencil.</p> <p>Next, define the page and region information for the form.</p> </li> <li> <p>For Define Form Page, edit the following:</p> <ol> <li> <p>Page Name - Enter <code>Create/Edit Employee</code>.</p> </li> <li> <p>Region Title - Enter <code>Create/Edit Employee</code>.</p> </li> <li> <p>Entry Name - Enter <code>Create/Edit Employee</code>.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>In Primary Key, accept the defaults and click <span class="bold">Next</span>.</p> </li> <li> <p>In Define the source for the primary key columns, accept the default, <a id="sthref186" name="sthref186"></a><a id="sthref187" name="sthref187"></a><span class="bold">Existing trigger</span>, and click <span class="bold">Next</span>.</p> <p>Your table, <code>OEHR_EMPLOYEES</code>, already has a trigger that populates the primary key.</p> </li> <li> <p>In Select Column(s), select all columns and click <span class="bold">Next</span>.</p> <p>These columns now appear in the Create/Edit Employee form.</p> </li> <li> <p>In Identify Process Options, accept the defaults and click <span class="bold">Next</span>.</p> <p>These selections enable users to add, update, and create employee records.</p> </li> <li> <p>For Confirm, verify the information and click <span class="bold">Finish</span>.</p> </li> </ol> <div class="sect2"><!-- infolevel="all" infotype="General" --><a id="sthref188" name="sthref188"></a> <h2>Previewing the <a id="sthref189" name="sthref189"></a><a id="sthref190" name="sthref190"></a><a id="sthref191" name="sthref191"></a><a id="sthref192" name="sthref192"></a>Pages</h2> <p>To preview the two pages you just created, run the current page. From the Employees report, you can then preview the form.</p> <p>To preview the pages:</p> <ol> <li> <p>Click the <span class="bold">Run Page</span> icon.</p> <img src="img/runpg_afterwiz.gif" alt="Description of runpg_afterwiz.gif follows" title="Description of runpg_afterwiz.gif follows" longdesc="img_text/runpg_afterwiz.htm" /><br /> <a id="sthref193" name="sthref193" href="img_text/runpg_afterwiz.htm">Description of the illustration runpg_afterwiz.gif</a><br /> <br /> <p>The Employees report appears.</p> <img src="img/bldap_empform.gif" alt="Description of bldap_empform.gif follows" title="Description of bldap_empform.gif follows" longdesc="img_text/bldap_empform.htm" /><br /> <a id="sthref194" name="sthref194" href="img_text/bldap_empform.htm">Description of the illustration bldap_empform.gif</a><br /> <br /> <p>Note the following about the Employees report:</p> <ul> <li> <p>The Edit icon you selected appears in each row. You can click the Edit icon to update the employee record.</p> </li> <li> <p>The Create button appears in the upper right corner. You can click the Create button to add an employee to the underlying table.</p> </li> <li> <p>The Employees report includes the five columns you specified. When you selected the columns and applied the changes, Oracle Application Express created the appropriate SQL code in the background to produce this result.</p> </li> </ul> <p>Your data might appear in a different order. If so, ignore this difference and continue with these steps.</p> </li> <li> <p>To review the form you also created, click the <span class="bold">Edit</span> icon in an Employee row.</p> <p>The Create/Edit Employee form appears.</p> <img src="img/bldap_empeditfrm.gif" alt="Description of bldap_empeditfrm.gif follows" title="Description of bldap_empeditfrm.gif follows" longdesc="img_text/bldap_empeditfrm.htm" /><br /> <a id="sthref195" name="sthref195" href="img_text/bldap_empeditfrm.htm">Description of the illustration bldap_empeditfrm.gif</a><br /> <br /> <p>Note the following about the <a id="sthref196" name="sthref196"></a>Create/Edit Employee form:</p> <ul> <li> <p>The form includes Cancel, Delete, and Apply Changes buttons.</p> </li> <li> <p>The Hire Date field displays a calender, which is included because the data type of the underlying column is <code>DATE</code>.</p> </li> </ul> </li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="td_blddptrprt.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="td_bldedit.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de