Week 11 April 12

1. Week 11April 12 Lexical Reference Variables in Graphics and List Box in Forms

2. Hard-Coded Values Will only show one year No flexibility

3. A Few Simple Steps • In Graphics Builder… • Create a user parameter • Assign an initial value • Modify the data model • Insert the lexical reference variable into the query • In Forms Builder • Create a list item • Populate the list box • Assign an initial value

4. A Few Simple Steps (cont.) • Create a push button to launch the graph in the chart item • Program the push button in PL/SQL • Create a paramlist variable • Concatenate the list item’s value to the text for the column name to form a text string • Add the text string to the parameter list • Open the graph • Run the form

5. In Graphics Builder

6. Create a Lexical Reference Variable Select Parameters and the create tool in the tool palette

7. Assign a Name and Initial Value Assign entries into the Name and Initial Value dialog boxes. Be sure the Type is character (char). Click OK.

8. Using the Lexical Reference Variable Replace with the lexical reference variable Replace the column name with the lexical reference variable

9. Using the Lexical Reference Variable Alias must be used Click Apply to test the syntax and OK to close the window

10. In Form Builder

11. Create the List Item Click on the list item tool in the tool palette and draw the list item on the canvas

12. Populate the List Item Right-mouse click on the list item (e.g., LIST10) and select the Property Palette

13. Populate the List Box 1. Select the Elements in List property, enter the elements and values, click on OK Must correspond Value associated with the list element 2. Assign an Initial Value (set to blank)

14. Navigator Block name Chart item name (Remember these names) List item name

15. Program the Push Button Right-mouse click on the push button and select PL/SQL Editor

16. Programming the Push Button Create a parameter list (runlist) If nothing is selected from the list box Take the year (i.e., last 2 digits) from the list box and append it to the literal (“sum(sales…”) See next slide

17. Programming the Push Button See next slide Assigns the variable revenue_year to the lexical reference variable, p_rev_column

18. block3.d_caption