< Previous | Next >

Running the SQL query

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.

To run the SQL query:

  1. Click anywhere in the SQL builder to enable the Run SQL command on the SQL menu.
  2. Click SQL > Run SQL. The Specify Variable Values window opens.
  3. Double-click the Value cell in the :CUSTNAME row, and then enter the string John Doe in the cell.

    Specify Variables Window with 'John Doe' string entered in the Value cell

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

Data Output view showing the results of running the query

< Previous | Next >