Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_item_pg_create.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 Page-Level Items</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:28Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Creating Page-Level Items" /> <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="bldapp.htm" title="Building an Application" type="text/html" /> <link rel="up" href="bldapp_item.htm" title="Understanding Page-Level Items" type="text/html" /> <link rel="up" href="bldapp_item_pg_create.htm" title="Creating Page-Level Items" type="text/html" /> <link rel="prev" href="bldapp_item_pgdef.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_item_edit.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="bldapp.htm" title="Building an Application">Building an Application</a> > <a href="bldapp_item.htm" title="Understanding Page-Level Items">Understanding Page-Level Items</a> > Creating Page-Level Items</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_item_pgdef.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_item_edit.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDDJDFA" name="CHDDJDFA"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25308" id="HTMDB25308"></a>Creating Page-Level <a id="sthref897" name="sthref897"></a>Items</h1> <p>You can create page-level items by running the Create Item Wizard.</p> <a id="sthref898" name="sthref898"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#CHDEIJJG">Creating a Page-Level Item on the Page Definition</a></p> </li> <li> <p><a href="#CEGDFBEA">About Item Naming Conventions</a></p> </li> <li> <p><a href="#BCEDCGGH">About Item Types</a></p> </li> <li> <p><a href="#CHDIFGIA">Creating Multiple Items Using Tabular Form</a></p> </li> <li> <p><a href="#CHDFDDII">Creating Multiple Items Using Drag and Drop</a></p> </li> <li> <p><a href="#CHDCDAEA">Creating a Static List of Values</a></p> </li> </ul> <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="bldapp_item_diffs.htm#BCEFHBHG">"Differences Between Page Items and Application Items"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="CHDEIJJG" name="CHDEIJJG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25309" id="HTMDB25309"></a>Creating a Page-Level Item<a id="sthref899" name="sthref899"></a> on the Page Definition</h2> <p>You create a page-level item by running the Create Item Wizard from the Page Definition.</p> <p>To create a page-level item:</p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>If necessary, create an HTML region. See <a href="ui_region.htm#CHDCIJJE">"Understanding Regions"</a>.</p> </li> <li> <p>Under Items, click the <span class="bold">Create</span> icon.</p> </li> <li> <p>Select an item type. See <a href="#BCEDCGGH">"About Item Types"</a>.</p> </li> <li> <p>Follow the on-screen instructions.</p> </li> <li> <p>To learn more about a specific field, click the field label.</p> <p>When help is available, the item label changes to red when you pass your cursor over it, and the cursor changes to an arrow and question mark. See <a href="start_hlp.htm#BABDGBDB">"About Field-Level Help"</a>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CEGDFBEA" name="CEGDFBEA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25310" id="HTMDB25310"></a>About Item Naming Conventions<a id="sthref900" name="sthref900"></a><a id="sthref901" name="sthref901"></a></h2> <p>When specifying an item name, remember the following rules. Item names must:</p> <ul> <li> <p>Be unique within an application</p> </li> <li> <p>Not have quotation marks</p> </li> <li> <p>Begin with a letter or a number, and subsequent characters can be letters, numbers, or underscore characters</p> </li> <li> <p>Be case-insensitive</p> </li> <li> <p>Should not exceed 30 characters</p> </li> <li> <p>Cannot contain letters outside the base ASCII character set</p> </li> </ul> </div> <!-- class="sect3" --> <a id="BCEDCGGH" name="BCEDCGGH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25311" id="HTMDB25311"></a>About <a id="sthref902" name="sthref902"></a>Item Types</h2> <p>When you create an item, you specify an item type. Once you create an item, these types appear on the Display As list on the Edit Page Item page. <a href="#BCEGHEAJ">Table: Available Item Types</a> describes available item types.</p> <div class="tblformalwide"><a id="sthref903" name="sthref903"></a><a id="BCEGHEAJ" name="BCEGHEAJ"></a> <p class="titleintable">Available Item Types</p> <table class="FormalWide" title="Available Item Types" summary="This table describes available item types." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="29%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t44">Item Type</th> <th align="left" valign="bottom" id="r1c2-t44">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t44" headers="r1c1-t44"> <p>Check Box<a id="sthref904" name="sthref904"></a><a id="sthref905" name="sthref905"></a></p> </td> <td align="left" headers="r2c1-t44 r1c2-t44"> <p>Displayed using a list of values. A list of values is required for items displayed as check boxes. The value corresponding to a checked box is returned in a single colon-delimited string.</p> <p>The following example demonstrates how to create a single check box that returns <code>YES</code>. This example would display both a check box and a field label.</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT NULL display_text, 'YES' return_value FROM DUAL; </pre> <p>This example includes the additional text <span class="italic">Click to select</span>.</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT 'Click to select' display_text, 'YES' return_value FROM DUAL; </pre> <p><span class="bold">See Also:</span> "APEX_UTIL" in <a href="http://www.oracle.com/pls/db112/lookup?id=AEAPI101"><span class="italic">Oracle Application Express API Reference</span></a> for information about breaking up returned values</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t44" headers="r1c1-t44"> <p>Date Picker<a id="sthref906" name="sthref906"></a><a id="sthref907" name="sthref907"></a></p> </td> <td align="left" headers="r3c1-t44 r1c2-t44"> <p>Displays a text field with a Calendar icon next to it. When clicked, this icon displays a small calendar where the user can select a date and a time (optional).</p> <p>If the format you need is not included in the Display As list, select <span class="bold">Date Picker (use application format mask)</span> or <span class="bold">Date Picker (use item format mask)</span>. The latter uses the value from the Format Mask field in the Source section of the Edit Page Item page.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t44" headers="r1c1-t44"> <p>Display Only<a id="sthref908" name="sthref908"></a></p> </td> <td align="left" headers="r4c1-t44 r1c2-t44"> <p>Available Display As Text subtypes include:</p> <ul> <li> <p><span class="bold">Display as Text (does not save state)</span> - Displays the item's source value on the page without creating a form item.</p> </li> <li> <p><span class="bold">Display as Text (escape special characters, does not save state)</span> - Displays the item's source value with special characters ('<','>','&') escaped.</p> </li> <li> <p><span class="bold">Display as Text (saves state)</span> - Displays the item's source value and creates a form item that gets submitted with the page to pass the value into session state.</p> </li> <li> <p><span class="bold">Display as Text (based on LOV, does not save state)</span> - Displays the display value from an LOV by matching the item's source value with the LOV's return value.</p> </li> <li> <p><span class="bold">Display as Text (based on LOV, saves state)</span> - Same as the previous option, but also generates a form item that gets submitted with the page to pass the return value into session state.</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t44" headers="r1c1-t44"> <p>File Browse<a id="sthref909" name="sthref909"></a></p> </td> <td align="left" headers="r5c1-t44 r1c2-t44"> <p>Displays a text field with a Browse... button. The Browse button enables the user to locate a file on a local file system and upload it. Oracle Application Express provides a table for these files to be uploaded to and an API to retrieve the files.</p> <p><span class="bold">See Also:</span> <a href="sec_sec_upload.htm#BABCICIC">"Securing File Uploads"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t44" headers="r1c1-t44"> <p>Hidden<a id="sthref910" name="sthref910"></a></p> </td> <td align="left" headers="r6c1-t44 r1c2-t44"> <p>Renders an HTML hidden form element. Session state can be assigned and referenced just like a text field.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t44" headers="r1c1-t44"> <p>Hidden and Protected<a id="sthref911" name="sthref911"></a></p> </td> <td align="left" headers="r7c1-t44 r1c2-t44"> <p>Renders an HTML hidden form element. Session state can be assigned and referenced just like a text field. For maximum security use <span class="bold">Hidden and Protected</span> instead of <span class="bold">Hidden</span> unless your page has client-side behavior, for example, JavaScript that alters the item value after the page is rendered by Oracle Application Express.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t44" headers="r1c1-t44"> <p>List Manager<a id="sthref912" name="sthref912"></a></p> </td> <td align="left" headers="r8c1-t44 r1c2-t44"> <p>Based on a list of values. This item enables you to manage a list of items by selecting and adding to a list. The list of values display as a popup.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t44" headers="r1c1-t44"> <p>Multiple Select<a id="sthref913" name="sthref913"></a></p> </td> <td align="left" headers="r9c1-t44 r1c2-t44"> <p>Renders as a multiselect HTML form element. When submitted, selected values are returned in a single colon-delimited string. You can break up the values using the <code>APEX_UTIL API</code>.</p> <p><span class="bold">See Also:</span> <a href="bldapp_item_lists.htm#CEGGEGJH">"Working with a Multiple Select List Item"</a> and "APEX_UTIL" in <a href="http://www.oracle.com/pls/db112/lookup?id=AEAPI101"><span class="italic">Oracle Application Express API Reference</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t44" headers="r1c1-t44"> <p>Password<a id="sthref914" name="sthref914"></a></p> </td> <td align="left" headers="r10c1-t44 r1c2-t44"> <p>Renders as an HTML password form element. Available password types include:</p> <ul> <li> <p><span class="bold">Password</span> - Suppresses text entered into the field. Saves the value in session state when the page is submitted.</p> </li> <li> <p><span class="bold">Password (submits when Enter pressed)</span> - Suppresses text entered into the field and submits the page when <span class="bold">ENTER</span> is pressed.</p> </li> <li> <p><span class="bold">Password (does not save state)</span> - Suppresses text entered into the field. Does not save the value in session state.</p> </li> <li> <p><span class="bold">Password (submits when Enter pressed, does not save state)</span> - Suppresses text entered into the filed and submits the page when <span class="bold">Enter</span> is pressed. Does not save the value in session state.</p> </li> </ul> <p>The <span class="bold">Password</span> and <span class="bold">Password (submits when Enter pressed)</span> save the password in a database table when the page is submitted. Use these password item types only when the password is needed in session state for use by other pages during the session.</p> <p><span class="bold">Password (does not save state)</span> and <span class="bold">Password (submits when Enter pressed, does not save state)</span> do not save the password in a database table. Use these password item types when the submitted password value is used only by after-submit page processing on the same page and is never needed again during the session.</p> <p>If you must reference and retrieve the value of a password in your application then you set the <span class="bold">Store value encrypted in session state</span> attribute to <span class="bold">Yes</span>. To learn more, see <a href="sec_session_encrypt.htm#CHDDAJHF">"About Session State and Security"</a>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t44" headers="r1c1-t44"> <p>Popup List of Values<a id="sthref915" name="sthref915"></a><a id="sthref916" name="sthref916"></a></p> </td> <td align="left" headers="r11c1-t44 r1c2-t44"> <p>Renders as a text field with an icon. When the user clicks the icon, a popup window appears with one of these, depending on the popup selection you make:</p> <ul> <li> <p>List of values represented as a series of links - When the user makes a selection from the list, the selected value is placed in the text field.</p> </li> <li> <p>Color picker - When the user makes a selection from the palette, the HTML value for the color selected (for example, #000000 for black) is returned.</p> </li> </ul> <p>With the exception of the color picker, you control popup lists of values through templates. You can only specify one popup list of values (LOV) template for each application. A popup LOV is a good choice for lists of values that are too large to return on a single page.</p> <p>There are two types of Popup LOVs: one that fetches a set of rows when the window pops up and one that does not. Available popup LOVs include:</p> <ul> <li> <p>Popup Key LOV (Displays description, returns key value)</p> </li> <li> <p>Popup Key LOV No Fetch (Displays description, returns key value without pre-fetch)</p> </li> <li> <p>Popup LOV (fetches first rowset and filters)</p> </li> <li> <p>Popup LOV (fetches first rowset)</p> </li> <li> <p>Popup LOV (no fetch)</p> </li> <li> <p>Popup Color Picker</p> </li> </ul> <p>Popup LOVs must be based on a query that selects two columns with different column aliases. For example:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT ename name, empno id FROM emp </pre> <p>If one of the columns is an expression, remember to use an alias. For example:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT ename||' '||job display_value, empno FROM emp </pre></td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t44" headers="r1c1-t44"> <p>Radio<a id="sthref917" name="sthref917"></a><a id="sthref918" name="sthref918"></a></p> </td> <td align="left" headers="r12c1-t44 r1c2-t44"> <p>Renders as an HTML radio group form element, based on a list of values. Choose <span class="bold">Radiogroup with Submit</span> to have the page submitted when the radio button is selected.</p> <p>The following example displays employee names (<code>ename</code>), but returns employee numbers (<code>empno</code>):</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT ename, empno FROM emp </pre></td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t44" headers="r1c1-t44"> <p>Select List<a id="sthref919" name="sthref919"></a><a id="sthref920" name="sthref920"></a></p> </td> <td align="left" headers="r13c1-t44 r1c2-t44"> <p>Displays using a list of values. A list of values is required for items displayed as a select list. Select lists are rendered using the HTML form element <code><select></code>. The values in a select list are determined using a named list of values or a list of values defined at the item level. You can specify the NULL display value and NULL return value.</p> <p>The following example would return employee names (<code>ename</code>) and employee numbers (<code>empno</code>) from the <code>emp</code> table. Note that column aliases are not required and are included in this example for clarity.</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT ename display_text, empno return_value FROM emp </pre> <p>Oracle Application Express provides additional enhancements to a standard HTML select list:</p> <ul> <li> <p><span class="bold">Select List with Submit</span> - Submits the page when the user changes its selected value. Upon submit, the REQUEST is set to the name of the item that represents the select list, allowing you to execute conditional computations, validations, processes, and branches.</p> </li> <li> <p><span class="bold">Select List with Redirect</span> - Redirects the user back to the same page, setting ONLY the newly selected value of the select list in session state.</p> </li> <li> <p><span class="bold">Select List Returning URL Redirect</span> - Based on a list of values with URLs as the return values. Changing the value of the select list causes the browser to redirect to the corresponding URL.</p> </li> <li> <p><span class="bold">Select List with Branch to Page</span> - Based on a list of values with page numbers as return values. Changing the selected value in the select list causes the Application Express engine to branch to the corresponding page.</p> </li> </ul> <p><span class="bold">Note</span>: Long select lists can cause errors. If you have a long select list that generates an error, try using a Popup List of Values instead.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t44" headers="r1c1-t44"> <p>Shuttle<a id="sthref921" name="sthref921"></a><a id="sthref922" name="sthref922"></a></p> </td> <td align="left" headers="r14c1-t44 r1c2-t44"> <p>Renders as a multiple select list that includes two boxes containing lists. The left list displays a source list of values. Users use the shuttle control icons and buttons to select list items and move them from the left (source) list to the right (destination) list. Each shuttle has five controls:</p> <ul> <li> <p>Move all - Moves all items in the source list to the destination list.</p> </li> <li> <p>Move selected - Moves only selected items (Ctrl + Shift items) to destination list.</p> </li> <li> <p>Remove selected - Moves only selected items (Ctrl + Shift items) to the source list.</p> </li> <li> <p>Remove all - Moves all items on destination list back to the source list.</p> </li> <li> <p>Refresh - Resets the source and destination lists.</p> </li> </ul> <p>The right destination list includes the sort controls Move to top, Move up, Move down, and Move to bottom.</p> <p><span class="bold">Note</span>: In order to create this item type, you must define a list of values. See <a href="#CHDCDAEA">"Creating a Static List of Values"</a>, <a href="bldapp_lov.htm#CHDFGFHI">"Creating Lists of Values"</a>, and <a href="bldapp_item_lists.htm#CEGGEGJH">"Working with a Multiple Select List Item"</a>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t44" headers="r1c1-t44"> <p>Text<a id="sthref923" name="sthref923"></a><a id="sthref924" name="sthref924"></a></p> </td> <td align="left" headers="r15c1-t44 r1c2-t44"> <p>Displays as an HTML text field containing a maximum of 30,000 bytes of text. You control the maximum length and display width by editing the Height and Width item attribute.</p> <p>Available Text display options include:</p> <ul> <li> <p><span class="bold">Text Field</span> - Renders as a text field.</p> </li> <li> <p><span class="bold">Text Field (Disabled, does not save state)</span> - Displays a read-only version of a display value from a list of values by using the item's value in session state to look up the corresponding display value in the associated list of values. The value displayed on the screen is not saved in session state upon submit.</p> </li> <li> <p><span class="bold">Text Field (Disabled, saves state)</span> - Displays a read-only version of a display value from a list of values by using the item's value in session state to look up the corresponding display value in the associated list of values.</p> </li> <li> <p><span class="bold">Text Field (always submits page when Enter pressed)</span> - Displays a read-only version of the value in session state. Upon submit, the value displayed is saved in session state.</p> </li> <li> <p><span class="bold">Text Field with Calculator Popup</span> - Renders as a text field with an icon next to it. When clicked, the icon displays a small window containing a calculator. Calculations are placed back in the text field.</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t44" headers="r1c1-t44"> <p>Text Area<a id="sthref925" name="sthref925"></a><a id="sthref926" name="sthref926"></a></p> </td> <td align="left" headers="r16c1-t44 r1c2-t44"> <p>Renders as an HTML text area. There is no maximum length for an item displayed as a text area. You control the height and width by editing the Height and Width item attribute. Additional available Text Area Display As options include:</p> <ul> <li> <p><span class="bold">Text Area</span></p> </li> <li> <p><span class="bold">Text Area (auto height)</span> - Varies the height based on the amount of text. Use this option to scale the text area to the amount of data.</p> </li> <li> <p><span class="bold">Text Area with Counter</span> - Includes a counter that displays the number of bytes entered in the field.</p> </li> <li> <p><span class="bold">Text Area with Spell Checker</span> - Provides a popup English language spell checker.</p> </li> <li> <p><span class="bold">HTML Editor Minimal</span> - Provides basic text editing features, including the application of bold, italics, and underline styles, the ability to create numbered and bulleted lists, and indentation.</p> </li> <li> <p><span class="bold">HTML Editor Standard</span> - Provides more editing functionality, such as font, format and color, than HTML Editor Minimal.</p> </li> <li> <p><span class="bold">Text Area with HTML Editor</span> - Provides basic text formatting controls. Note that these controls may not work in all Web browsers.</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t44" headers="r1c1-t44"> <p>Stop and Start Table<a id="sthref927" name="sthref927"></a><a id="sthref928" name="sthref928"></a></p> </td> <td align="left" headers="r17c1-t44 r1c2-t44"> <p>Forces the close of an HTML table using the <code></table></code> tag and starts a HTML table. You can use this item type to reset the column width in the middle of the region.</p> <p>Note that a Stop and Start Table item only displays its label. You can prevent the label from displaying at all by setting it to null. To do this, you simply remove the default label.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformalwide" --></div> <!-- class="sect3" --> <a id="CHDIFGIA" name="CHDIFGIA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25312" id="HTMDB25312"></a>Creating Multiple Items Using Tabular Form</h2> <p>To create multiple items simultaneously:</p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>If necessary, create an HTML region. See <a href="ui_region.htm#CHDCIJJE">"Understanding Regions"</a>.</p> </li> <li> <p>Under Items, click the <span class="bold">Create</span> icon.</p> <p>The Create Item wizard appears.</p> </li> <li> <p>At the bottom of the page, click the <span class="bold">Create multiple Items Using Tabular Form</span> link.</p> </li> <li> <p>On the Create Multiple Items page, specify the following:</p> <ol> <li> <p>Create Item(s) in Region - Select the region to contain the items.</p> </li> <li> <p>Item Template - Select an item template.</p> </li> <li> <p>For each item, enter the Sequence, Name, Label, Type and specify whether the item should be cached.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Create Multiple Items</span>.</p> </li> </ol> <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="bldapp_item_pgdef.htm#CHDHHFGI">"About the Drag and Drop Icon"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="CHDFDDII" name="CHDFDDII"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25313" id="HTMDB25313"></a>Creating Multiple Items Using Drag and Drop</h2> <p>To create multiple items using the Drag and Drop Layout page:</p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>If necessary, create an HTML region. See <a href="ui_region.htm#CHDCIJJE">"Understanding Regions"</a>.</p> </li> <li> <p>Under Items, click the <span class="bold">Create</span> icon.</p> <p>The Create Item wizard appears.</p> </li> <li> <p>At the bottom of the page, click the <span class="bold">Create multiple Items Using Drag and Drop Layout</span> link.</p> <p>The Drag and Drop Layout page appears.</p> </li> <li> <p>Select an item from the palette on the left side of the page and drag it to the appropriate position on the page.</p> </li> <li> <p>Edit the item attributes at the of the page.</p> <ol> <li> <p>Display Name - Enter an item name. Use this name retrieve the value of the item. Item names longer than 30 characters cannot be referenced using bind variable syntax.</p> </li> <li> <p>Label - Enter the label for this item. You may include HTML, JavaScript, and shortcuts. You can also use the substitution string <code>#CURRENT_ITEM_NAME#</code> to obtain the name of the item associated with this label.</p> </li> <li> <p>Display Type - Select a display type (if applicable). See <a href="#BCEDCGGH">"About Item Types"</a>.</p> </li> </ol> </li> <li> <p>To edit an existing item, edit the Item Name and Label fields, or select a new Display Type at the top of the page.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>Optionally, edit the each item's Name and Label.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <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_layout.htm#CHDBJGCD">"Using the Drag and Drop Layout Page"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="CHDCDAEA" name="CHDCDAEA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25314" id="HTMDB25314"></a>Creating a Static List of <a id="sthref929" name="sthref929"></a>Values</h2> <p>One way to create a static list of values is to edit an item's List of Values definition. Note that this type of list of values is not reusable. As a best practice, create a list of values as a shared component whenever possible.</p> <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="bldapp_lov.htm#CHDFGFHI">"Creating Lists of Values"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>To create a static list of values:</p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Items, select the item name.</p> <p>The Edit Page Item page appears.</p> </li> <li> <p>Under Name, specify how the item will be rendered. Make a selection from the Display As list.</p> </li> <li> <p>Under List of Values, create a static list of values:</p> <ol> <li> <p>From Named LOV, select <span class="bold">Select Named LOV</span>.</p> </li> <li> <p>In List of values definition, enter a definition using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> STATIC[2]:<span class="italic">Display Value</span>[;<span class="italic">Return Value</span>],<span class="italic">Display Value</span>[;<span class="italic">Return Value</span>] </pre> <p>Where:</p> <ul> <li> <p>The first keyword may be <code>STATIC</code> or <code>STATIC2</code>.</p> <p><code>STATIC</code> results in the values being sorted alphabetically by display value. <code>STATIC2</code> results in the values being displayed in the order they are entered in the list.</p> </li> <li> <p>A semicolon separates the display value from the return value in each entry.</p> </li> <li> <p><code>Return Value</code> is optional. If a <code>Return Value</code> is not included, the return value is the same as the display value.</p> </li> </ul> </li> </ol> </li> <li> <p>To learn more, see item Help. To view help for a specific item on a page, click the item label.</p> <p>When help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See <a href="start_hlp.htm#BABDGBDB">"About Field-Level Help"</a>.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> <p>The examples that follow demonstrate syntax for three different static LOVs.</p> </li> </ol> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref930" name="sthref930"></a> <h3><a name="HTMDB25315" id="HTMDB25315"></a>Example 1: Four Values Displayed in Alphabetical Order</h3> <p>In this example, the list of values has four values (Cow, Dog, Cat, and Lion) that display in alphabetical order. The return value of each entry equals the display value.</p> <pre xml:space="preserve" class="oac_no_warn"> STATIC:Cow,Dog,Cat,Lion </pre></div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref931" name="sthref931"></a> <h3><a name="HTMDB25316" id="HTMDB25316"></a>Example 2: Ten Values Displayed in the Order Listed</h3> <p>In this example, the list of values has ten values that display in the order listed in the definition. The return value of each entry equals the display value.</p> <pre xml:space="preserve" class="oac_no_warn"> STATIC2:10,15,20,25,50,100,200,500,1000,10000 </pre></div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref932" name="sthref932"></a> <h3><a name="HTMDB25317" id="HTMDB25317"></a>Example 3: A List of Values with Having Both a Return and Display Value</h3> <p>In this example, the list of values has two values: <code>Yes</code> and <code>No</code> (the display value <code>Yes</code> and its return value <code>Y</code>, and the display value <code>No</code> and its return value <code>N</code>).</p> <pre xml:space="preserve" class="oac_no_warn"> STATIC:Yes;Y,No;N </pre> <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 Control Form Layout" in <span class="italic"><a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD004">Oracle Application Express Advanced Tutorials</a></span></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect4" --></div> <!-- class="sect3" --></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_item_pgdef.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_item_edit.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