Before you incorporate the SQL query into the video store application,
you need to test the query to ensure that it returns correct results. You
can do this by using the SQL builder.
- Click anywhere in the SQL builder to enable the Run
SQL command on the SQL menu.
- Click . The Specify Variable Values window opens.
- Double-click the Value cell in the :CUSTNAME
row, and then enter the string John Doe in the cell.

After you press Enter, the name is automatically embedded
in single quotation marks.
- Click Finish.
Your query runs, and the results are displayed in the Data Output
view.
