Activity 10.04 – Parameterized stored procedure (series list)
You have been asked to modify the code tagged as SQL 8
to call spSeriesList_par()
from a passthrough query and assign it to the cmbSeries
row source. Perform the following steps to implement this activity:
- Locate the SQL code in VBA marked
SQL 8
. - Comment out the existing SQL statement. Hint: When you are modifying code, always comment out the original lines of code before creating a new line. This gives you a) a reference to the original code and b) an easy way to reinstate the original code if required. You can remove the line after you have tested and confirmed the new code is working.
- Create a SQL statement for the passthrough query. This time, pass the filter value to the stored procedure in the brackets and, as we are passing in a string, ensure it is enclosed in single quotes.
- Assign the resulting passthrough to the dropdown.
After implementing these steps, the expected output should...