For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Creating the Create Button

At this point, there is one button missing.  The missing button is the Create button that is used to navigate to the application page where a form will allow the creation of new rows.  Since our own form has not been created yet, the Create button will be added and it will navigate to application page two for now.

Navigate to the Page Definition page for the Report, which is application page 11.  If an application page is running, click on the Edit Application link in the developer toolbar, and then click on the Conference RSVP Report link in the Application home page.

1.       From the Page Definition page, click on the  icon in the Buttons region.

2.       On the Button Region, page click Next.

3.       On the Button Position page, choose the Create a button in a region position option and click Next.

4.       On the Button Attributes page:

·         Button Name: CREATE

The [Create] link can be used to do this.

·         Label: Create

·         Button Type: Template Driven

·         Action: choose the Redirect to URL without submitting page option.

What this does is prevent the creation of a separate Branch.  Since the goal is to get the Report page to redirect (navigate) to page two, and a branch is not required, this option can be chosen.  Even though a branch can do the same thing, there is no need to have one.  The maintenance of the page components can be kept lower by not creating the branch.

·         Click Next.

5.       On the Image Attributes page leave the default and click Next.

6.       On the Display Properties page:

·         Position: Region Template Position #CREATE#

The [Create] link can be used to do this.

·         Leave the rest default and click Next.

7.       On the Branching page:

·         Target: Page in this Application.

·         Page: 2

·         Request: leave blank

Leaving this option blank will cause HTML DB to set the request to the Button Name (CREATE).  If the developer wanted to have a different request name, it could be entered here.  The request can be used in Conditional Displayproperties to detect what the request was set to when the page was submitted.

·         Clear Cache: 2

This clears the session state for all page items on page two.  All the page items will be set to null.  The cache for multiple pages can be cleared by separating them by a comma.

·         There are no Conditional Display attributes that need to be set for this button, so it is not necessary to go to the next page.  Click the Create Button button.

Run the report by clicking the  icon in the upper right corner of the Page Definition page.

The finished report is shown in Figure 7.9.  You may ask yourself “Why would I want to build a report manually instead of use the wizard?”  Well, with more experience, developers usually find that a wizard will not always do what is needed.  The steps in the previous lessons will give the experience needed to build your own reports or modify those that have already been built using the wizard.

Later in this chapter there are other tips on how to do even more with reports, but due to space constraints it is not possible provide step-by-step instructions for all of them.  The experience gained so far will be valuable in knowing how to accomplish those later lessons.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm


For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

   
  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: