Database Reference
In-Depth Information
Display Value
Return Value
Tim
TIM
(Your Name)
(YOUR NAME)
8.
Click
Create List of Values
when you're finished.
Now that you've created a static LOV, let's include a second one that uses a SQL
query to derive the list of values:
9. Repeat steps 1 through 4.
10. Create a second list named
USERS
, selecting the
Dynamic
option.
Click
Next
.
11. Locate the topic supplemental file
ch5_lov.txt
that includes the
SQL query text. Enter the SQL query for the LOV source.
12. Click
Create List of Values
You should now have two LOVs. Don't worry if you made a mistake. All the set-
tings can be modified—simply click the name of the LOV you want to modify.
Summary
In this chapter, you created the basic shell of an application and several of the support-
ing objects that you use in the upcoming chapters. These items have been created as a
result of planning that was done prior to starting the application. Depending on your
situation, the amount of planning you do for your own application may vary. The
shared components outlined here can be created at any time as needed during the de-
velopment process. In the next section you start using some of the key structures out-
lined here.
