Defining a Query 2

We could create this query by hand, entering an SQL request directly, but Caché provides an easier way: the Query Wizard. Open Film in Studio.

1. On the Studio menu bar, click Class —>Add —>Query.

   

2. EnterTopFilms as the Name. Click This query is based on an SQL statement under Implementation and then add a Description.

3. Click Next. This displays the Input Parameters screen.

   

4. At this stage we will not add any parameters to the query. Later, we will modify the query to accept a parameter. Click Next.