Create an application for user product’s price data entry.

This application will be used to query the product's price table, and update, delete and insert the product's price information.

The window size for product price should be small enough to fit on a small portion of the application's window. The users’ requirements state that they want to have a push button object to click on it and then run the product's price application from the main application.  You should modify their application to provide such request.

You will learn how to:  call another form.

 

	More Resources by Google:

Save the Form name as version 11.

Open the items "tap" canvas.

Create a push button that calls the “Product Price” data entry application.

First, you should create a new Form for this application..

Select "Forms"  and click on the "create" icon.

Save the Form in the iself folder as "prod_de."  Short for product price data entry.

Create a "Data block" using the "data block wizard" option.

Select the "Price" table and all of it’s columns.

Use the default canvas option.

Select all the columns.

Select the “tabular” option.

Type the "frame title."

Change "records displayed."

Checkmark “Display Scrollbar.”

Then click on “Finish.”

Open its “Window” property palette.

Change the "X” position to 50.

Change the "Width" length to 300.

Change the "Height" length to 150.

Then, close the window.

This is the boarder of  the display window.

Close the window.

Save the Form in the iself folder.

Then compile it.

Click on the “Push Button” icon then click and drag it onto the layout editor.

Open it's property palette.

Change the name property to a more meaningful naming convention; then press the enter key.

Change "Label" to “Product Data Entry.”

Change the Keyboard and Mouse Navigate to "NO.”

Close the window.

Notice that on the object navigator this push button is not in the “item” block.

Move it to the “Item” block.

Notice that its location was changed;

and that five items were displayed.

Open it's property palette and change "number of items displayed" to 1.

Press the enter key and close the window.

Move the push button item.

Right Click on the push button to choose "smart triggers," and select "WHEN-BUTTON-PRESSED."

Write a PL/SQL procedure to open the “Product Price” data entry application.

Compile the trigger; and close the window.

Run the application.

Click “Execute Query.”

Navigate through the application options.

Click on the “Product Data Entry” push button.

Then click “Execute Query” again.

All products will be displayed.

Click on the "Enter Query" icon to query all product prices for a specific product.

Close the window.

Navigate through the application to check all the changes.

When you are done with the testing, close the application and save the changes.

Now, you should practice this over and over, until you become a master at it.

Good Luck!