everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

Manuscript: 14

 

 

Topics:  Hands-On 11

 

Since you had inserted the employee pictures into the EMP table successfully, now the organization wants to view the pictures that were inserted.

 

You have been assigned to develop an application form to display all of the employee information plus their picture.

 

   
   

Manuscript

-- Hands-On 11 (Display the picture using the BLOB datatype from Developer V6i)

Click on the form name and change the color to blue.

Then type "EMPLOYEE_DATA" as the form name.

Click on the "Data Blocks" item and then click on the "Create" icon.

Use the Data Block wizard to create a data block.

Click on the "Next" button in the window screen.

Select the "Table" option and then click "Next."

Click on the "Browse" button and select the EMP table.

Click on the "OK" button to save and close the "tables" window.

Select all the columns of the employee table.

Click on the "NEXT" button.

Now, click on the "FINISH" button to create the data block, and then call the Layout Wizard.

Click on the "Next" button.

Use the "Content" canvas, which should be the default setting and click on the "Next" button.

Select all the columns that are going to be displayed on the canvas.

Click on the "Next" button.

Change the prompt if it is needed.

Chose the "Form" option and click "Next."

Type "Employee Data Information" on the title item and then click on the "NEXT" button.

Click on the "Finish" button.

You can resize the photo image as needed. See how we resize the photo image. you know how big your original picture is. If the box is too small, you may only see a part of the picture and not the whole.

Run the application form and maximize the "Forms Runtime" window.

Click on the "Execute Query" icon to display an employee record.

Navigate through your application. Notice that we only added pictures to the first two employees in the employee table.

Exit the form.

Go to the "Object Navigator" windows and highlight the "EMPLOYEE_DATA" Form.

Save the "EMPLOYEE_DATA" form in the default "form builder" folder.

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

Good Luck.

 

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.