8 Building an Application

Creating a New Application

You can use the Create Application Wizard to create a new application having up to nine pages.

To create an application using the Create Application Wizard:

1. Navigate to the Workspace home page.

2. Click the Create Application button.

3. Choose the method by which you want to create your application:

   • From Scratch. Enables you to define tabs, select a user interface (UI), and many other options.

   • Based on an Existing Application. Creates a copy of another application, including any authentication settings, but without any the pages. Select this option to create an application using the same user interface templates as an existing application.

   • Based on an Existing Table. Creates a complete application based on an existing table in your workspace. The resulting application includes a standard report, an insert form, an update form, a success form (indicates when a record is successfully inserted), an analysis menu page, analysis reports, analysis charts, and a login page.

   • Demonstration Application. Installs a demonstration application included with Oracle HTML DB.

   • Based on Spreadsheet. Creates an easily deployable application from a spreadsheet.

   • From an Application Export File. Uploads an application export file.

4. Follow the on-screen instruction.

   Once you create an application the next step is to specify application attributes.

Deleting an Application

You can delete an application from the Application Builder home page, or while editing application attributes. If you delete an application you also delete all defined components (reports, charts, or forms), page controls (buttons, items, list of values), or a shared components (menus, lists, or tabs).

To delete an application from Application Builder home page:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application.

3. When Application Builder appears, verify the application name and the application ID at the top of the page.

4. From the Tasks list, select Delete this Application.

5. Follow the on-screen instructions.

To delete an application while editing application attributes:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application.

3. When Application Builder appears, verify the application name and the application ID at the top of the page.

4. Click the Edit Attributes icon.

   The Edit Application Attributes page appears.

5. Verify the application ID and name.

6. Click Delete at the top of the page.

Creating a Page from Application Builder

To create a new page from the Application Builder home page:

1. Navigate to Workspace home page.

2. From the Applications list, select an application.

3. On the Application Builder home page, click Create Page.

4. Select the type of page you wish to create:

   • Blank Page

   • Page with Component

     Select Page with Component to create a page containing a report, a chart, a form, a wizard, a calendar, or a tree. Selecting this option creates complete pages containing multiple attributes. For example, the Report wizard generates one page containing one region and multiple buttons.

5. Follow the on-screen instructions.

Creating a Page from the Page Definition

To create a new page while viewing a Page Definition:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. From the navigation bar at the top of the page, click the Create button.

3. Select the type of page you wish to create:

   • Blank Page

   • Page with Component

     Select Page with Component to create a page containing a report, a chart, a form, a wizard, a calendar, or a tree. Selecting this option creates complete pages containing multiple attributes. For example, the Report wizard generates one page containing one region and multiple buttons.

4. Follow the on-screen instructions.

Creating a Page from the Developer Toolbar

Users who log in to Oracle HTML DB having developer privileges have access to the Developer toolbar. The Developer toolbar displays at the bottom every page and offers a quick way create a new page.

To create a new page from the Developer toolbar:

1. On the Developer toolbar, select New.

   The New Component Wizard appears.

2. Select the type of page you want to create:

   • Page (Blank Page)

   • Component (Report, Form, Chart)

   • Page Control (Region, Item, Button)

   • Shared Control (Menu, List, Tab)

3. Follow the on-screen instructions.

Running a Page

The HTML DB engine dynamically renders and process pages based on data stored in database tables. To view a rendered version of your application, you run or submit it to the HTML DB engine. As you create new pages you can run them individually, or run an entire application. You can run a page from numerous locations within Application Builder by clicking the Run icon. (See Figure 8-1.)

Figure 8-1 Run Icon on the Pages List

Description of the illustration run_ico_sm.gif

To run a specific page from the Pages list:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application.

   Application Builder appears. The list of pages for the selected application appears at the bottom of the page.

3. From the Pages list, locate the page you wish to run and click the Run button in the far right column.

To run a specific page from the Page Definition:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. Click the Run button in the upper right corner of the page.

To run an entire application:

1. Navigate to the Workspace home page.

2. Locate the application in the Applications list.

3. Click the Run button in the far right column.

Grouping Pages

You can make the pages within your application easier to access by organizing them into page groups.

Topics in this section include:

• Creating a Page Group

• Assigning Pages to a Page Group

• Viewing the Page Group Report

Locking and Unlocking Page

You can prevent conflicts during application development by locking pages of your application. By locking a page, you prevent other developers from editing it.

To lock a page of your application:

1. Navigate to the Workspace home page.

2. From the Applications list, select the application.

3. To lock pages from the Locked Pages page:

   1. From the Tasks List on the right side of the page, select Manage Page Locks.

   2. Select the appropriate pages and click Lock.

   3. Enter a comment in the Comment field.

   4. Click Lock Pages.

4. To lock pages from the Pages list:

   1. Click the Lock icon in the Pages list.

   2. Enter a comment in the Comment field.

   3. Click Lock Pages.

5. To lock pages from the Page Definition:

   1. Navigate to the Page Definition. (See "Viewing a Page Definition".)

   2. Click the Lock icon in the upper right corner above Shared Components.

      The Locked Pages page appears.

   3. Select the appropriate pages and click Lock.

   4. Enter a comment in the Comment field.

   5. Click Lock Pages.

Only the user who locked a page can unlock it.

To unlock a page of your application:

1. Navigate to the Workspace home page.

2. From the Applications list, select the application.

3. To unlock pages from the Locked Pages page:

   1. From the Tasks List on the right side of the page, select Manage Page Locks.

   2. Select the appropriate pages.

   3. Click UnLock.

4. To unlock pages from the Pages list:

   1. Click the Lock icon in the Pages list.

      The Edit Page Lock page appears.

   2. Click UnLock.

5. To unlock pages from the Page Definition:

   1. Navigate to the Page Definition. (See "Viewing a Page Definition".)

   2. Click the Lock icon in the upper right corner above Shared Components.

      The Locked Pages page appears.

   3. Select the appropriate pages.

   4. Click UnLock.

Note the Lock icon changes to reflect the lock status of a given page.

Deleting a Page

You can delete a page from the Page Definition or while editing page attributes.

To delete a page from the Page Definition:

1. Navigate to the Page Definition. (See "Viewing a Page Definition".)

2. Verify the page name.

3. From the navigation bar at the top of the page, click Delete.

4. Follow the on-screen instructions.

To delete a page while editing page attributes:

1. Navigate to the Page Definition. (See "Viewing a Page Definition".)

2. From the navigation bar at the top of the page, click Edit Attributes.

3. Verify the application ID and page name.

4. Click Delete.

5. Follow the on-screen instructions.

Creating a Report Using a Wizard

Oracle HTML DB includes the number of built-in wizards for generating reports.

To create a report using a wizard:

1. Navigate to the Workspace home page.

2. From the Applications list, select the application.

   Application Builder appears.

3. Click Create Page.

4. Select Page with Component.

5. Select Report.

6. Select one of the following report types:

   • Easy Report - Does not require any SQL knowledge. Simply select the appropriate schema, table, columns, and result set display.

   • Report with Form - Builds a two page report and form combination. The first page enables users to specify the row to be updated. The second page includes a form for updating the selected table or view.

   • SQL Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide.

7. Follow the on-screen instructions.

Editing Report Attributes

You can use the Report Attributes and Column Attributes pages to precisely control the look and feel of report pages. For example, you can use these attributes to alter column heading text, change column positioning, hide a column, create a sum of a column, or select a sort sequence.

On the Page Definition, you can access the Report Attributes page by clicking either Q or RPT adjacent to the report region you want to edit. Q indicates the report is a regular report and RPT indicates the report is an easy report. You can also navigate to the Report Attributes page by clicking the region name then selecting the Report Attributes tab.

To access the Report Attributes page:

1. Navigate to the Workspace home page.

2. From the Applications list, select the application.

3. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

4. Under Regions, click Q next to the name of the report region you want to edit.

   The Report Attributes page appears.

   Figure 8-2 Report Attributes Page

   
   Description of the illustration rpt_att.gif
   
   

   Heading Type identifies how the heading was generated for the report. Use the Report Column Attributes section to control report column appearance and functionality. The Link column indicates whether a column link is currently defined. The Edit column indicates whether or not a column is currently updatable. The Edit column.

   Table 8-1 describes common report column edits.

   Table 8-1 Common Report Column Edits

   Description	Developer Action
   Alter column display sequence.	Click the up and down arrows.
   Alter heading alignment.	Under Column Alignment, select a new column alignment.
   Change column heading text.	Under Heading, enter a different heading text.
   Control which columns display.	Click Show to indicate a column should display.
   Enable an unique sort sequence.	Click Sort and select a sequence number from Sort Sequence.
   Enable the sum of a column.	Click Sum to enable the sum of a column.

   
   

   You can further refine the attributes of a specific column on the Column Attributes page.

5. To access the Column Attributes page, click the Edit icon adjacent to the appropriate column name.

   See online help for more information on a specific attribute.

Controlling Report Pagination

You control report pagination by:

• Including a pagination substitution string in the report template

• Making selections from Layout and Pagination on the Report Attributes page

You control how pagination displays by making selections from the Layout and Pagination attributes on the Report Attributes page.

To access the Layout and Pagination section of the Report Attributes page:

1. Create a report. (See "Creating a Report Using a Wizard".)

2. Under Regions, click the appropriate report attributes link (Q or RPT).

   The Report Attributes page appears.

3. Scroll down to Layout and Pagination.

   You use the Layout and Pagination attributes to select a pagination style, determine where pagination displays, and specify the number of rows that display on each page. Table 8-2 describes the most commonly used Layout and Pagination attributes.

Enabling Column Sorting

You enable column sorting on the Report Attributes page.

To enable column sorting:

1. Navigate to the Report Attributes page. (See "Editing Report Attributes".)

2. Under Report Column Attributes, select the Sort check box adjacent to the columns to be sorted.

3. From Sort Sequence, select a sequence number.

   Sort Sequence is optional. However, if there are one or more sort enabled columns, then at least one column needs a defined Sort Sequence.

4. Scroll down to Sorting.

5. Specify ascending and descending image attributes or click set defaults.

Exporting a Report as a CSV or XML File

You can create a link within a report that enables users to export the report as either a comma delimited file (.csv) or XML file. You specify an export format by selecting a report template.

To specify an export report template:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Scroll down to Layout and Pagination.

3. From the Report Template list, select one of the following:

   • export: CSV exports the report as a CSV file

   • export: XML exports the report as a XML file

   Selecting either option prevents the HTML DB engine from rendering the page and dumps the content to either a CSV or XML file.

   You can use the options under CSV Output to create a link that downloads the content of the report.

4. Scroll down Report Export.

5. From Enable SCV output, select Yes.

6. (Optional) In the Separator and Enclosed By fields, define the separator and delimiter characters.

   The default Enclosed By by characters are a double quotes (" "). The default delimiter character is either a comma or a semicolon depending upon your current NLS settings.

7. In the Link Label field, enter link text. This text will display in your report and enable users to invoke a download.

8. (Optional) To specify a default export filename, enter a name in the Filename field.

   By default, the HTML DB engine creates an export filename by taking the region name and adding the appropriate filename extension (.csv or .xml).

9. Click Apply Changes.

Creating a Column link

Use the Column Link attributes to create a link from a report to another page in your application or to a URL.

To create a column link to another page:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Under Report Column Attributes, locate the column to contain the link.

3. Click the Edit icon adjacent to the column name.

   The Column Attributes page appears.

4. Scroll down to Column Link.

5. To create a Column Link to another page:

   1. From Target, select Page in this Application.

   2. (Optional) In Link Attributes, specify additional column link attributes that will be included in the <a href= > tag (for example, a link target, classes, or styles).

   3. In Link Text, enter text to be displayed as a link, specify an image tag, or pick from the list of default images.

   4. In Page, specify the target page number. To reset pagination for this page, select Reset Pagination.

   5. In Request, specify the request to be used.

   6. In Clear Cache, specify the pages (that is, the page numbers) on which to clear cache. You can specify multiple pages by listing the page numbers in a comma delimited list.

   7. Use the Name and Value fields to specify session state for a specific item.

6. Click Apply Changes.

To create a column link to a URL:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Access the Column Attributes page by clicking the Edit icon adjacent to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to Column Link.

4. Under Column Link, make the following selections

   1. From Target Type, select URL.

   2. In Link Text, enter text to be displayed as a link, select a substitution string.

   3. (Optional) In Link Attributes, specify additional column link attributes that will be included in the <a href= > tag (for example, a link target, classes, or styles).

   4. In URL, enter the appropriate address.

5. Click Apply Changes.

Defining an Updatable Column

You can make a column updatable by editing Tabular Form Element attributes on the Column Attributes page. Note that the HTML DB engine can only perform updates if a multi row update is defined, or PL/SQL process is implemented to process updated data.

To define updatable column attributes:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Access the Column Attributes page by clicking the Edit icon adjacent to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to Tabular Form Element.

4. Under Tabular Form Element, make the following selections:

   1. From Display As, select a type of updatable column.

      Use this option to make a column updatable. Updates can only be performed if a multi row update is defined, or PL/SQL process is implemented to process updated data.

   2. From Date Picker Format Mask, make a selection if you selected the Display As type of Date Picker.

   3. In Element Width, specify the width of the form item.

   4. In Number of Rows, specify the height of a form item (applicable to text areas).

   5. In Element Attributes, define a style or standard form element attribute.

   6. In Element Option Attributes, specify form element attributes for items in a radio group or check box.

   7. From Default Type, identify the default type.

   8. In Default, identify the default source.

      Use Default Type and Default Source to add new rows to a tabular form. The HTML DB engine uses this setting to determine the default value for the column. Otherwise, the column is defined as NULL.

   9. From Reference Table Owner, identify the owner of the referenced table. Use this attribute to build User Interface Defaults for reports.

   10. In Reference Table Name, identify the table or view that contains the current report column.

   11. In Reference Column Name, identify the column name that this report column references

5. Click Apply Changes.

Defining a Column as a List of Values

Report columns may be rendered as lists of values. For example, a column can be rendered using a select list or a popup list of values. Or, a column can also be rendered as read-only text based on a list of values.

This last approach is an effective strategy when creating display lookup values and is particularly useful in regular, non-updatable reports. This approach enables you to display the value of a column without having to write a SQL JOIN.

To render a report column as a list of values:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Access the Column Attributes page by clicking the Edit icon adjacent to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to List of Values.

4. From Named LOV, make a selection from the Named List of Values repository.

5. To include a null value in a list of values:

   1. In Display Null, select Yes.

   2. In Null Text, specify the value that displays.

   A column may also have a value that does not display in its list of values.

6. To define a value that does not display in the list of values:

   1. From Display Extra Value, select Yes.

      The extra value is used if the actual column value is not part of the LOV. In that situation, the actual value is shown. If you do not display extra values, you may end up with the wrong value and unintentionally and update your data incorrectly.

   2. In Null Value, specify the value that displays.

   3. If you have not selected a Named LOV, enter the query used to display a select list in the LOV Query field.

7. If you have not selected a Named LOV, enter the query used to display a select list in LOV Query.

8. Click Apply Changes.

Controlling When Columns Display

You can use the Authorization and Conditional Display column attributes to control when a column displays.

Authorization enables you to control access to resources (such as a report column) based on predefined user privileges. For example, you could create an authorization scheme in which only managers can view a specific report column. Before you can select an authorization scheme, you must first create it.

A condition is a small unit of logic that enables you to control the display of a column based on a predefined condition type. The condition evaluates to true or false based on the values you enter in the Expressions fields.

To specify Authorization and Conditional Display attributes:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Access the Column Attributes page by clicking the Edit icon adjacent to the appropriate column.

   The Column Attributes page appears.

3. Under Authorization, make a selection from the Authorization Scheme list.

4. Under Conditional Display, make a selection from the Condition Type list and depending upon your selection, enter an expression or value in the appropriate Expression fields.

   If the authorization is successful and the condition type display evaluates to true, the column displays.

Controlling Column Breaks

You can control whether a specific column repeats and how column breaks appear when printed using Break Formatting attributes. For example, suppose your report displays employee information by department number. If multiple employees are members of the same department, you can increase the readability by specifying the department number only appears once.

To create this type of column break:

1. Navigate to the appropriate Report Attributes page. (See "Editing Report Attributes".)

2. Scroll down to Break Formatting.

3. Make a selection from the Breaks list.

Creating a Form Using a Wizard

The easiest way to create a form is to use a wizard. For example, the Form on Table or View Wizard creates one item for each column in a table. It also includes the necessary buttons and processes required to insert, update, and delete rows from the table using a primary key. Each region has a defined name and display position all other attributes are items, buttons, processes, and branches.

To create a form using a wizard:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application.

   Application Builder appears.

3. Click Create Page.

4. Select Page with Component.

5. Select Form.

6. Under Forms, select a wizard described in Table 8-3.

   Table 8-3 Forms Wizards

   Wizard	Description
   Form on a Procedure	Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or DML (Data Manipulation Language) in a stored procedure or package.
   Form on a SQL Query	Creates a form based on the columns returned by a SQL query such as an equijoin.
   Form on a Table or View	Creates a form that enables users to update a single row in a database table.
   Form on a Table with Report. 2 pages	Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record. Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns will generate an error.
   Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button. See Also: "Creating a Form on a Web Service"
   Form and Report on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report. See Also: "Creating an Input Form and Report on a Web Service"
   Master Detail Form	Creates a form which displays a master row and multiple detail rows within a single HTML form. With this form, users can query, insert, update, and delete values from two tables or views. See Also: "Building a Master Detail Form"
   Summary Page	Creates a read-only version of a form. Typically used to provide a confirmation page at the end of a wizard.
   Tabular Form	Creates a form in which users can update multiple rows in a database. See Also: "Creating a Tabular Form"

   
   

7. Follow the on-screen instructions.

Creating a Tabular Form

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.

To create a tabular form:

1. From the Workspace home page, select the appropriate application.

2. Click Create Page.

3. Select Page with Component.

4. Select Form.

5. Select Tabular Form.

   The Tabular Form Wizard appears.

6. On Identify Table/View Owner:

   1. Specify the table or view owner on which you want to base your tabular form.

   2. Select the type of tabular form you want to create.

   3. Select a table.

7. On Identify Table/View Name, select a table.

8. On Identify Columns to Display:

   1. Specify whether to use user interface defaults.

      User interface defaults enable you to assign default user interface properties to a table, column, or view within a specified schema.

   2. Select the columns (updatable and nonupdatable) to include in the form.

      You can modify the column order or your SQL query after you have created the page.

9. On Identify Primary Key, select the Primary Key column and a foreign key column (if applicable).

10. On Defaults for Primary and Foreign Keys, select a source type for the primary key column. Valid options include:

    • Existing trigger - Select this option if a trigger is already defined for the table. You do not need to define a primary key column source for existing columns. Existing columns already have a primary key.

    • Custom PL/SQL function - Select this option if the source is a PL/SQL function returning the key value.

    • Existing sequence - Select this option if an existing sequence is defined for the table. If that is the case, the sequence next value would be used.

11. On Updatable Columns, select which columns should be updatable.

12. On Identify Page and Region Attributes.

    1. Specify page and region information.

    2. Select a region template.

    3. Select a report template.

13. On Identify Tab, specify a tab implementation for this page.

14. On Button Labels, enter the display text to appear on the Cancel, Submit, Delete, and Add Row buttons.

15. On Identify Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons.

16. Click Finish.

Building a Master Detail Form

A master detail form reflects a one-to-many relationship between two tables in a database. Typically a master detail form displays a master row and multiple detail rows within a single HTML form. With this form, users can insert, update, and delete values from two tables or views.

To create a master detail form:

1. From the Workspace home page, select the appropriate application.

2. Click Create Page.

3. Select Page with Component.

4. Select Form.

5. Select Master Detail Form.

   The Master Detail Wizard appears.

6. On Define Master Table:

   1. Select a table or view owner

   2. Select a table or view name

   3. Select the columns to display

7. On Define Detail Table:

   1. Specify to show only related tables

   2. Select the table or view owner

   3. Select the table or view name

   4. Select the columns to display

8. On Define Primary Key, select the primary key column for the master table and then the primary key column for the detail table.

9. On Define Master and Detail, define the relationships between master and detail tables.

10. Specify the source for the master table and detail table primary key columns.

11. On Define Master Options, specify whether to include master row navigation.

    If you include master row navigation, define navigation order columns. If a navigation order column is not defined, the master update form will navigate by the primary key column.

12. On Choose Layout, specify the layout of the master detail pages.

    You can include the master detail as a tabular form on the same page, or add the master detail on a separate page.

13. On Page Attributes, review and edit the master page and detail page information.

14. On Identify Tabs, specify whether to include an optional tab set.

15. Click Create.

Creating a Form Manually

You can also create a form manually by performing the following steps:

• Create an HTML region (to serve as a container for your page items)

• Create items to display in the region

• Create processes and branches

To create a form manually:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. Create an HTML region:

   • Under Regions, click Create

   • Select the region type HTML

   • Follow the on-screen instructions

3. Start adding items to the page:

   • Under Items, click Create

   • Follow the on-screen instructions

BEGIN
  INSERT INTO T ( first_name, last_name )
     VALUES  (:P1_FIRST_NAME, :P1_LAST_NAME);
END; 

BEGIN
    UPDATE T
       SET first_name = :P1_FIRST_NAME,
           last_name = :P1_LAST_NAME
    WHERE ID = :P1_ID;
END; 

BEGIN
    DELETE FROM T
    WHERE ID = :P1_ID;
END;

FOR C1 in (SELECT ename, sal
FROM emp WHERE ID=:P2_ID)
LOOP     
     :P2_ENAME := C1.ename;
     :P2_SAL := C1.sal;
END LOOP;

Validating User Input in Forms

You can use validations to check data a user types prior to processing. Once you create a validation and the associated error message, you can associate it with a specific item. You can choose to have validation error messages display inline (that is, on the page where the validation is performed) or on a separate error page.

Creating an inline error message involves these steps:

• Create a new validation and specify error message text

• Associate the validation with a specific item

To create a new validation:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. Under Validations, click the Create icon.

3. When the Create Validations Wizard appears, follow the on-screen instructions.

   Validations Types are divided into two categories:

   • Item. These validations start with the phrase "Item" and provide common checks you may want to perform on the item that the validation is associated with.

   • Code. These validations require you provide either a piece of PL/SQL code or SQL query that defines the validation logic. Use this type of validation to perform custom validations that require verifying values of more than one item or accessing additional database tables.

4. Follow the on-screen instructions.

To associate an item with a validation and specify error message text:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. Under Validations, select the validation item you want to associate.

   The attributes page for the validation appears.

3. Scroll down to Error Messaging:

   • In Error message display location, verify the display location

   • In Associated Item, select the item you want to associate with this validation

4. Click Apply Changes.

About SVG Plug-in Support

The Adobe SVG plug-in can properly handle data encoded in UTF-8, UTF-16, ISO-8859-1, and US-ASCII. Encoding of an SVG chart is determined by the database access descriptor (DAD) database character set. If the DAD character set is not UTF8, AL32UTF8, AL16UTF16, WE8ISO8859P1, or US7ASCII, SVG charts may not render properly in the Adobe SVG plug-in.

About Creating Charts

You define a chart in Oracle HTML DB using a wizard. For most chart wizards, you select a chart type and provide a SQL query using the following syntax:

SELECT link, label, value
FROM   ...

Where:

• link is a URL

• label is the text that displays in the bar

• value is the numeric column that defines the bar size

For example:

SELECT null, ename, sal
FROM   scott.emp
WHERE  deptno = :P101_DEPTNO

To create a dial chart, select a dial chart type and provide a SQL query using the following syntax:

SELECT value , maximum_value [ ,low_value [ ,high_value] ]
FROM   ...

Where:

• value is the starting point on the dial

• maximum_value is the possible highest point on the dial

• low_value and high_value are the historical low and high values

For example:

select dbms_random.value(500, 1200), 1300, dbms_random.value(100, 200)
FROM DUAL

Table 8-4 describes the chart types available in Oracle HTML DB.

Creating a New Chart

How you create a chart depends upon whether you are adding the chart to an existing page, or adding a chart on a new page.

Editing Chart Attributes

Once you have created a chart you can alter its display by editing chart attributes on the chart attributes page.

To access the Chart Attributes page:

1. Navigate to the Page Definition.

2. Under Regions, click Chart next to the name of the chart region you wish to edit.

   The Chart Attributes page appears.

   Note that removing the chart title (that is, the Chart Title attribute) may negatively impact the location and display of the chart legend.

Understanding Chart CSS Classes

When you create a new chart, Oracle HTML DB renders it based on cascading style sheet (CSS) classes associated with the current theme. You can change the appearance of a chart by referencing another CSS or by overriding individual classes in the CSS section of the Edit Attributes page

The following sample contains the CSS classes for the dial chart in Sample Application. This example contains all the available CSS classes. Class names appear in boldface.

text{font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;fill:#000000;}
tspan{font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;fill:#000000;}
text.title{font-weight:bold;font-size:14;fill:#000000;}
text.moredatafound{font-size:12;}
rect.legend{fill:#EEEEEE;stroke:#000000;stroke-width:1;}
text.legend{font-size:10;}
#background{fill:#FFFFFF;stroke:none;}
rect.chartholderbackground{fill:#ffffff;stroke:#000000;stroke-width:1;}
#timestamp{text-anchor:start;font-size:9;}
text.tic{stroke:none;fill:#000000;font-size:12}
line.tic{stroke:#000000;stroke-width:1px;fill:none;}
#dial{stroke:#336699;stroke-width:2px;fill:#336699;fill-opacity:.5;}
#dial.alert{fill:#FF0000;fill-opacity:.5;}
#dialbackground{stroke:#000000;stroke-width:none;fill:none;filter:url(#MyFilter);}
#dialcenter{stroke:none;fill:#111111;filter:url(#MyFilter);}
#dialbackground-border{stroke:#DDDDDD;stroke-width:2px;fill:none;filter:url
(#MyFilter);}#low{stroke-width:3;stroke:#336699;}
#high{stroke-width:3;stroke:#FF0000;}
#XAxisTitle{letter-spacing:2;kerning:auto;font-size:14;fill:#000000;text-anchor:middle;}
#YAxisTitle{letter-spacing:2;kerning:auto;font-size:14;fill:#000000;text-anchor:middle;writing-mode:tb;}
.XAxisValue{font-size:8;fill:#000000;}
.YAxisValue{font-size:8;fill:#000000;text-anchor:end;}
.nodatafound{stroke:#000000;stroke-width:1;font-size:12;}
.AxisLine{stroke:#000000;stroke-width:2;fill:#FFFFFF;}
.GridLine{stroke:#000000;stroke-width:0.3;stroke-dasharray:2,4;fill:none;}
g.dataholder rect{stroke:#000000;stroke-width:0.5;}
.legenditem rect{stroke:#000000;stroke-width:0.5;}

Table 8-5 describes all supported CSS class. Note that certain classes only apply to specific chart types.

rect.legend{fill:#CCCC99;stroke:none;} 

#background{fill:#FFFFFF;stroke:#FFFFFF;stroke-width:2;}

rect.chartholderbackground(display:none;)

"#timestamp{display:none;}" 

Referencing a Custom Cascading Style Sheet

You can reference a custom cascading style sheet for a chart using the CSS section of the Chart Attributes page. When you reference an external CSS, you can reference it entirely or simply override specific styles.

To reference a custom chart CSS:

1. Upload the CSS to Oracle HTML DB. (See "Uploading Cascading Style Sheets").

2. Create a chart. (See "Creating a New Chart".)

3. Navigate to the Page Definition.

4. Under Regions, click Chart next to the region name.

   The Chart Attributes page appears.

5. Scroll down to the CSS section.

6. From Use Custom CSS, select Yes.

7. To reference an external CSS exclusively:

   1. In Custom CSS, Link enter a link to a custom CSS. For example:

      #IMAGE_PREFIX#themes/theme_4/svg.css
      
      

   2. Specify that the CSS should be used exclusively. In Custom CSS, Inline enter the following:

      /**/
      
      

8. To reference a custom CSS and override specific styles:

   1. In Custom CSS, Link enter a link to a custom style sheet. For example:

      #IMAGE_PREFIX#themes/theme_4/svg.css
      
      

   2. In Custom CSS, Inline, enter the custom CSS styles you want to override.

Specifying Custom CSS Styles Inline

You can override specific styles within the default CSS, using the Custom CSS, Inline attribute on the Chart Attributes page.

To override specific styles within the default CSS:

1. Create a chart. (See "Creating a New Chart".)

2. Navigate to the Page Definition.

3. Under Regions, click Chart next to the region name.

   The Chart Attributes page appears.

4. Scroll down to CSS.

5. From Use Custom CSS, select Yes.

6. In Custom CSS, Inline, enter the custom CSS styles you want to override.

Enabling Asynchronous Updates

You can create charts that monitor information by enabling the Asynchronous Update attribute on the Chart attributes page. Enabling this attribute updates the chart to reflect changes in the underlying data within a specified time interval.

To enable asynchronous updates:

1. Create a chart. (See Creating a New Chart.)

2. Navigate to the Page Definition.

3. Under Regions, click Chart next to the region name.

   The Chart Attributes page appears.

4. Scroll down to Refresh.

5. From Asynchronous Update, select Yes.

6. In Update Interval (Seconds), enter the interval in seconds between chart updates. For optimal performance, select an interval that is greater than 2 seconds.

When Asynchronous Update is enabled, a timestamp displays on the chart indicating that last update.

To disable the Asynchronous Update timestamp:

1. Navigate to the Chart Attributes page.

2. Locate the CSS section.

3. From Use Custom CSS, select Yes.

4. In Custom CSS, Inline edit #timestamp as follows:

   #timestamp{display:none;}
   

Displaying Charts in Other Languages

To display a chart in another language, you edit the text and tspan classes to reflect the correct language.

To display a chart in another language:

1. Navigate to the Chart Attributes page. (See Editing Chart Attributes.)

2. Scroll down to CSS.

3. From Use Custom CSS, select Yes.

4. In Custom CSS, Inline, edit the text and tspan classes to reflect the correct language. The following example demonstrates how to change a chart to Korean:

   text{font-family:Batang;fill:#000000;}
   tspan{font-family:Batang;fill:#000000;}
   
   

Creating a Button Using a Wizard

You create a button by running the Create Button Wizard from the Page Definition. Each button resides in a region. A region is a area on a page that serves as a container for content.

To create a new button:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. If necessary, create an HTML region. (See "Customizing Regions".)

3. Under Buttons, click the Create icon.

   The Create Button Wizard appears.

4. Select a region to contain the button.

5. Select a position for the button:

   • Create a button displayed among this region's items

   • Create a button in a region position

   Select Create a button displayed among this region's items to add a button to a region as if it was an item (for example, to add a button directly to the right of a form field).

6. If you select Create a button in a region position:

   1. Specify the Button Name and Label.

   2. Select a Button Type: HTML Button (Default), Image, or Template Driven

      Select Button is Reset to create an Undo button. When enabled, this type of button resets the page values to the state they were in when the page was initially rendered.

   3. Select an Action.

      Selecting Submit page and redirect to URL submits the current page to the HTML DB engine whenever a user clicks the button.

      Selecting Redirect to URL without submitting page avoids submitting the page. Choose this action when submitting the page for processing is not necessary (for example, a Cancel button). This action avoids processing in the database and therefore reduces the load.

7. If you select Create a button displayed among this region's items:

   1. Specify the Button Name and Sequence.

   2. Specify whether the button displays at the beginning of a new line or new field.

   3. Specify a Label.

   4. Enter the value of Request.

   5. Select the Button Style.

8. Follow the on-screen instructions

Creating Multiple Buttons

You can create multiple buttons within the same region at once using the Create Multiple Buttons Wizard.

To create multiple buttons at once:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. If necessary, create an HTML region. (See "Customizing Regions".)

3. Under Buttons, click the Create icon.

   The Create Button Wizard appears.

4. From the Tasks list, select Create Multiple Buttons.

   The Create Multiple Button Wizard appears.

5. From Place Buttons in Region, select the region to contain the buttons.

6. From Template, select a template.

7. In HTML Attributes, Specify HTML attributes for these buttons. This text will be added to the HTML element definition. For example, you could set the class of a text button as follows:

   class="myclass"
   
   

8. To quickly populate the remaining fields, select make a selection from the Quick Button list on the right side of the page.

9. Click Create Buttons.

Understanding the Relationship Between Button Names and REQUEST

The name you give a button determines the value of the built-in attribute REQUEST. You can reference the value of REQUEST from within PL/SQL using the bind variable :REQUEST. By using this bind variable, you can conditionally process, validate, or branch based on which button the user clicks. You can also create processes that execute when the user clicks a button. You can also use a more complex condition as demonstrated in the following examples:

If :REQUEST in ('EDIT','DELETE') then ...
If :REQUEST != 'DELETE' then ...

These examples assume the existence of buttons named EDIT and DELETE. You can also use this syntax in PL/SQL Expression conditions. Be aware, however, that the button name case is preserved. In other words, if you name a button "LOGIN" then a request looking for the name "Login" will fail. For example:

<input type="BUTTON" value="Finish" onClick="javascript:doSubmit('Finish');">

Note that in this example Finish is the name of the REQUEST and this example is case-sensitive.

About Branching with Buttons

Each page can include any number of branches. A branch links to another page in your application or to a URL. The HTML DB engine considers branching at different times during page processing. You can choose to branch before processing, before computation, before validation, and after processing. Like any other control in Application Builder, branching can be conditional. For example, you can branch when a user clicks a button. When you create a branch, you associate it with a specific button. The branch will only be considered if a user clicks the button.

Displaying Buttons Conditionally

You can choose to have a button display conditionally by editing attributes on the Edit Pages Button page.

To have a button display conditionally:

1. Create the button. (See "Creating a Button Using a Wizard".)

2. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

3. Under Buttons, select the button name.

   The attributes page for the button appears.

4. Scroll down to Conditional Button Display.

5. Make a selection from the Condition Type list.

6. Enter an expression in the fields provided.

7. Click Apply Changes.

Creating a Page Level Item

You create a page level item by running the Create Item Wizard from the Page Definition.

To create a new page level item:

1. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

2. If necessary, create an HTML region. (See "Customizing Regions".)

3. Under Items, click the Create icon.

4. Select an item type. (See "About Item Types".)

5. Follow the on-screen instructions

SELECT NULL display_text, 'YES' return_value FROM DUAL;

SELECT 'Click to select' display_text, 'YES' return_value FROM DUAL;

SELECT ename, empno FROM emp

SELECT ename||' '||job display_value, empno FROM emp

SELECT ename, empno FROM emp

SELECT ename display_text, empno return_value FROM emp

Referencing Item Values

You can reference item values stored in session state in regions, computations, processes, validation, and branches. Table 8-7 describes the supported syntax for referencing item values.

You can set the value of an item in your application using any of the following methods:

• For page items, use the Source Attribute to set the item value.

  From the Page Definition, select the item name to view the Edit Page Item page. Scroll down to Source and edit the appropriate fields.

  You can also set the value of an item in any region based on PL/SQL or a process using the following syntax:

  BEGIN
   :MY_ITEM :=  'new value';
  END;
  
  

• Pass the value on a URL reference using f?p syntax. For example:

  f?p=100:101:10636547268728380919::NO::MY_ITEM:ABC
  
  

• Set the value using a computation. Computations are designed to set item values. For example:

  TO_CHAR(SYSDATE,'Day DD Month, YYYY');
  
  

• Use the PL/SQL API to set an item value within a PL/SQL context. For example:

  HTMLDB_UTIL.SET_SESSION_STATE('MY_ITEM',SYSDATE);
  
  

Displaying Conditional or Read-only Items

You can choose to have an item display conditionally or as read-only by editing attributes on the Edit Pages Item page.

To display a conditional or read-only item:

1. Create the item. (See "Creating a Page Level Item".)

2. Navigate to the appropriate Page Definition. (See "Viewing a Page Definition".)

3. Under Items, select the item name.

   The attributes page for the item appears.

4. To display an item conditionally:

   1. Scroll down to Conditional Display.

   2. Make a selection from the Condition Type list.

   3. Enter an expression in the fields provided.

5. To make an item read-only:

   1. Scroll down to Read Only Display Settings.

   2. Make a selection from the Read Only Condition Type list.

   3. Enter an expression in the fields provided.

6. Click Apply Changes.

Creating an Application Level Item

Application level items do not display, but are used as global variables to the application. To reference an application level item you must set a value by using an ON_NEW_INSTANCE computation.

To create a new application level item:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application name.

3. When Application Builder appears, click Shared Components.

4. Under Logic, select Items.

   The Application Items page appears.

5. To create a new application item, click the Create icon.

6. Follow the on-screen instructions.

Populating an Alternative Date Picker Format

If you need to create a Date Picker item, but the format you need does not appear in the Display As list, you should select Date Picker (use application format mask). When an application uses this type of date picker, the HTML DB engine derives the date format from an item named PICK_DATE_FORMAT_MASK. You can populate this item in two ways:

• By defining an application substitution string named PICK_DATE_FORMAT_MASK

• By creating an application level item named PICK_DATE_FORMAT_MASK

Creating Named LOVs at the Application Level

You define named (or shared) LOVs at the application level by running the Create LOV Wizard and adding them to the Named List of Values repository. All LOVs can be defined as static or dynamic. Static lists are based on predefined pairs of display and return values. Dynamic lists are based on a SQL query you write that selects values from a table.

To create a named LOV:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application name.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Lists of Values.

5. To create a new LOV, click the Create icon.

6. Follow the on-screen instructions.

   New named LOVs are added to the Named List of Values repository.

About Static LOVs

Static LOVs are based on a static list of display and return values you specify when you run the Create LOV Wizard. To create a static LOV you run the Create LOV Wizard and select the LOV type Static. Oracle HTML DB stores the display values, return values, and sort sequence you specify in the Named List of Values repository. Once you add a static LOV to the repository you can create an item and display it as a check box, radio group, select list, or popup list based on this definition.

About Popup LOVs

Using a popup LOV is a good choice for lists of values that are too large to return on a single page. Popup LOVs create an icon to the right of a standard text field. When the user clicks this icon, a popup window appears with a list of values represented as a series of links. When the user selects from this searchable list, the selected value will be placed in the text field. You control popup LOVs through templates. You can only specify one popup LOV template for each application.

Popup LOVs must be based on a query that selects two columns with different column aliases. For example:

SELECT ename name, empno id 
   FROM emp

Referencing Session State within a LOV

You can reference session state by using bind variables. In the following example, this LOV only works if the item called my_deptno contains a valid department number.

SELECT ename, empno FROM emp WHERE deptno = :my_deptno

Accessing LOV Reports

Application Builder includes a number of reports designed to help you better manage LOVs, including:

• Bulk Update LOV Data Values

• Subscribed LOVs

• LOV Utilization

• LOV Change History

To access LOV reports:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application name.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Lists of Values.

5. Select one of the following buttons at the top of the page:

   • Edit all lists of values entries

   • Subscription

   • Utilization

   • History

6. Follow the on-screen instructions.

About Creating Calendars

Oracle HTML DB supports two calendar types:

• Easy Calendar creates a calendar based on schema, table, and columns you specify. The wizard prompts you to select a date column and display column.

• SQL Calendar creates a calendar based on a SQL query you provide. The SQL SELECT statement you provide must include at least two columns, a date column and display column.

The date column determines which days on the calendar will contain entries. The display column defines a specific row that will display a calendar date.

Creating a New Calendar

How you create a calendar depends upon whether you are adding a calendar to an existing page, or adding a calendar on a new page.

Converting an Easy Calendar to a SQL Calendar

Creating an Easy Calendar is the simplest way to create a calendar in Oracle HTML DB. However, if you find the resulting calendar does not meet your needs, you can quickly convert it to SQL Calendar.

To convert an Easy Calendar to a SQL Calendar:

1. Navigate to the Page Definition.

2. Under Regions, click CAL next to the region name.

   The Calendar Attributes page appears.

3. From the Tasks list, select Convert to SQL Based calendar.

   Converting an Easy Calendar to a SQL Calendar, adds a Region Source section to the Region Definition. The Region Source contains the original SQL query that creates the calendar. By having accessing the Region Source, you can easily edit the query to meet your needs.

Editing a Calendar Title

The title that appears at the top of calendar corresponds to the region title.

To alter the region title:

1. Navigate to the Page Definition.

2. Under Regions, select the region name.

   The Region Definition appears.

3. Under Region, enter a new title.

4. Click Apply Changes.

Editing Calendar Attributes

Once you have created a calendar you can alter how it appears by editing its attributes.

Topics in this section include:

• Accessing the Calendar Attributes Page

• Calendar Display

• Calendar Interval

• Column Link

• Day Link

About Shortcut Types

When you create a new shortcut, you must specify the type of shortcut you wish to create. Oracle HTML DB supports the following shortcut types:

• PL/SQL Function Body

• HTML Text

• HTML Text with Escaped Special Characters

• Image

• Text with JavaScript Escaped Single Quotes

• Message

• Message with JavaScript Escaped Special Quotes

Defining Shortcuts

Before you can incorporate a shortcut in your application, you must define it and add it to the Shortcuts repository. You reference new shortcuts using the following syntax:

"MY_SHORTCUT"

Note that the shortcut name must be capitalized and enclosed in quotes.

To define a new shortcut:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application name.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Shortcuts.

5. Click Create.

6. Select one of the following creation methods:

   • From Scratch

   • As a Copy of an Existing Shortcut

7. Follow the on-screen instructions.

New shortcuts are added to the Shortcut repository and are available for use within the following locations:

• The Region Source attribute of regions defined as HTML Text (with shortcuts). (See "Customizing Regions".)

• Region Header and Footer Text attribute (See "Specifying a Region Header and Footer".)

• Item Label attributes and Item Default Value attribute. (See "Items".)

• Region Templates attributes. (See "Editing Templates".)

Accessing Shortcut Reports

Application Builder includes a number of reports designed to help you better manage LOVs, including:

• Subscribed Shortcuts

• Shortcut History

To access of report detailing recent shortcut changes:

1. Navigate to the Workspace home page.

2. From the Applications list, select an application name.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Shortcuts.

5. Click Create.

6. Follow the on-screen instructions.

About Referencing Items Using JavaScript

When you reference an item, the best approach is to reference by ID. If you view the HTML source of an Oracle HTML DB page in a Web browser, you would notice that all items have an ID attribute. This ID corresponds to name of the item, not the item label. For example, if you create an item with the name P1_FIRST_NAME and a label of First Name, the ID will be P1_FIRST_NAME.

Knowing the item ID enables you to use the JavaScript function getElementById to get and set item attributes and values. The following example demonstrates how to reference an item by ID and display its value in an alert box.

<script language="JavaScript1.1" type="text/javascript">
  function firstName(){    
    alert('First Name is ' + document.getElementById('P1_FIRST_NAME').value );
  }
 // or a more generic version would be
  function displayValue(id){    
    alert('The Value is ' + document.getElementById(id).value );
  }
</script>
 
  // Then add the following to the "Form Element Attributes" Attribute of the item:
  onChange="javascript:displayValue('P1_FIRST_NAME');"

While it is possible to reference items using the HTML form element attribute name (represented in the previous example as form p_t01), this is strongly discouraged. Remember that the name attribute is dynamic and is determined at when a page is rendered. For example, suppose the first element rendered on a page is p_t01 and the second is p_t02. If you write a function that references p_t01 and then create a new item on the page that appears first, the item that was p_t01 will now be p_t02 and your function will break.

How to Incorporate JavaScript Functions

There are two primary places to include JavaScript functions:

• In the HTML Header attribute of the page

• In a .js file in the page template.

<script language="JavaScript1.1" type="text/javascript>
  function test(){
    alert('This is a test.');
  }
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>#TITLE#</title>
    #HEAD#
    <script src="#APP_IMAGES#custom.js" type="text/javascript"></script>
</head>
<body #ONLOAD#>#FORM_OPEN#

Calling JavaScript from a Button

Calling a JavaScript from a button is a great way to confirm a request. Oracle HTML DB actually uses this technique for the delete operation of most objects. For example, when you delete a button, a JavaScript Alert Box appears asking you to confirm your request. Consider the following example:

<script language="JavaScript1.1" type="text/javascript">
  function deleteConfirm(msg)
  {
var confDel = msg;
if(confDel ==null)
  confDel= confirm("Would you like to perform this delete action?");
else
  confDel= confirm(msg);
  
if (confDel== true)
  doSubmit('Delete');
  }
</script>

This example creates a function to confirm a delete action and then calls that function from a button. Note that the function optionally submits the page and sets the value of the internal variable :REQUEST to Delete, thus performing the delete using a process that conditionally executes based on the value of request.

Note that when you create the button you would need to select Action Redirect to URL without submitting page. Then, you would specify a URL target such as the following:

javascript:confirmDelete('Would you like to perform this delete action?');

Creating a Help Page and Region

The first step in creating a help for your application it to create a dedicated page and Help Text region.

To create a new Help Text region:

1. Create new page for your help. (See "Adding Additional Pages".)

2. Navigate to the Page Definition of your help page. (See "Viewing a Page".)

3. Under Regions, the Create icon.

4. When prompted to select a region type, select Help Text.

5. Follow the on-screen instructions.

Defining Help Text

You define help text for a page or single item by editing attributes. Ideally, you would define these attributes as you create your application. For simplicity, however, the following procedures describe how to define this text after the fact.

To define page help text:

1. Navigate to the Page Definition for the page for which you want to add page help. (See "Viewing a Page".)

2. Click Edit Attributes to view the existing page attributes.

3. Scroll down to Page Help Text.

4. Enter your help text in the field provided.

5. Click Apply Changes.

Repeat the previous procedure for each page requiring page help text.

To define item help text:

1. Navigate to the Page Definition for the page for which you want to add item help.

2. Under Items, click name of the item you want to edit.

3. Scroll down to Help Text.

4. Enter your help text in the field provided.

5. Click Apply Change.

Repeat the previous procedure for each item requiring help text.

Creating a Help Navigation Bar Icon

Once you have created your help, the next step is to create a navigation bar icon so users can link to it.

To create a navigation bar icon:

1. Navigate to the Page Definition. (See "Viewing a Page".)

2. Under Navigation Bar, click the Create icon.

3. Specify the appropriate NavBar entry attributes:

   • Sequence

   • Alt Tag Text

   • Icon Image Name

   • Image Height and Image Width

   • Text

   Specify the target location.

4. To specify the target location:

   • From Target type, select Page in this application.

   • In Page, specify the page number.

   • In Request, type:

     &APP_PAGE_ID.
     
     

   By specifying substitution string &APP_PAGE_ID as the Request, you are instructing the HTML DB engine to display help text for the current page when the user clicks this icon.