|
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.
-- 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. |
