Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_frm_tab.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>Creating a Tabular Form</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:29Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Creating a Tabular Form" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-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="app_comp.htm" title="Adding Application Components" type="text/html" /> <link rel="up" href="bldapp_frm.htm" title="Creating Forms" type="text/html" /> <link rel="up" href="bldapp_frm_tab.htm" title="Creating a Tabular Form" type="text/html" /> <link rel="prev" href="bldapp_frm_create.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_frm_detail.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="app_comp.htm" title="Adding Application Components">Adding Application Components</a> > <a href="bldapp_frm.htm" title="Creating Forms">Creating Forms</a> > Creating a Tabular Form</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="bldapp_frm_create.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm_detail.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEECEFA" name="BCEECEFA"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB05030|form, tabular"></a>Creating a Tabular <a id="sthref1073" name="sthref1073"></a><a id="sthref1074" name="sthref1074"></a>Form</h1> <p>A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.</p> <p>To create a tabular form:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select an application.</p> </li> <li> <p>Click <span class="bold">Create Page</span>.</p> </li> <li> <p>Select <span class="bold">Form</span> and click <span class="bold">Next</span>.</p> </li> <li> <p>Select <span class="bold">Tabular Form</span> and click <span class="bold">Next</span>.</p> <p>The Tabular Form Wizard appears.</p> </li> <li> <p>For Table/View Owner:</p> <ol> <li> <p>Specify the table or view owner on which you want to base your tabular form.</p> </li> <li> <p>Select the operations to be performed on the table (for example, <span class="bold">Update, Insert and Delete</span>).</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Table/View Name, select a table and click <span class="bold">Next</span>.</p> </li> <li> <p>For Displayed Columns:</p> <ol> <li> <p>Select the columns (updatable and nonupdatable) to include in the form.</p> <p>Note that you can modify the column order or your SQL query after you create the page.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Primary Key, select the Primary Key column and a secondary Primary Key column (if applicable) and click <span class="bold">Next</span>.</p> </li> <li> <p>For Primary Key Source, select a source type for the primary key column and click <span class="bold">Next</span>. Valid options include:</p> <ul> <li> <p><span class="bold">Existing trigger</span> - Select this option if a trigger is defined for the table. You can also select this option if you plan on specifying the primary key column source later after completing the form.</p> </li> <li> <p><span class="bold">Custom PL/SQL function</span> - Select this option if you want to provide a PL/SQL function to generate returning key value.</p> </li> <li> <p><span class="bold">Existing sequence</span> - Select this option if you want to pick the sequence from a list of sequences available in the selected schema.</p> </li> </ul> </li> <li> <p>On Updatable Columns, select which columns should be updatable and click <span class="bold">Next</span>.</p> </li> <li> <p>On Page and Region Attributes:</p> <ol> <li> <p>Specify page and region information.</p> </li> <li> <p>Select a region template.</p> </li> <li> <p>Select a report template.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>On Tab, specify a tab implementation for this page and click <span class="bold">Next</span>.</p> </li> <li> <p>On Button Labels, enter the display text to appear for each button and click <span class="bold">Next</span>.</p> </li> <li> <p>On Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons and click <span class="bold">Next</span>.</p> </li> <li> <p>Click <span class="bold">Finish</span>.</p> </li> </ol> <div align="center"> <div class="inftblnote"><br /> <table class="Note oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Note:</p> Any modification of the select list of a SQL statement of a tabular form after it has been generated is not recommended. If you do modify the query, make sure the values of the updateable columns are not altered after being queried from the database by the Application Express engine.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnote" --></div> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="ui_default.htm#CHDCIFCC">"Managing User Interface Defaults"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Tutorial:</p> ""How to Create a Tabular Form" in <a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD001"><span class="italic">Oracle Application Express Advanced Tutorials</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect2" --> <!-- 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="bldapp_frm_create.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm_detail.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