Database Reference
In-Depth Information
TICKET_DETAILS_ID
for
Primary Key Column 1
,
MIME_TYPE
for
Mimetype Column
,
FILE_NAME
for
Filename Column
, and
Download
for
Download Text
, as shown in
Figure 6-77
.
Figure 6-77.
Modifying the BLOB column attributes
10. Scroll to the top of the page, and click
Apply Changes
.
Run the application. Test the file upload and download capabilities by attaching a
file to one of the Ticket Details records and then downloading it from the report.
This ability to easily upload and download files in APEX is extremely useful in
building web applications where users need to upload and download data for whatever
purpose. The Declarative BLOBs feature of APEX makes it simple for developers to
add upload and download capabilities to an application.
Summary
You've reviewed most of the APEX form and report types and walked through building
various forms and reports for your Help Desk system using the APEX form and report
wizards. Along the way, you've learned about APEX items, session state, the APEX
URL syntax, adding help to APEX pages, and incorporating upload and download
functionality by using the Declarative BLOBs feature. That's a lot to digest, but the
APEX wizards have done most of the work for you.
The common theme is that the APEX form and reports wizards are huge time-savers
for developers, creating all the objects—items, buttons, branches, processes, and so