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.
On the Studio menu bar, click Class —>Add —>Query.
EnterTopFilms as the Name. Click This query is based on an SQL statement under Implementation and then add a Description.
Click Next. This displays the Input Parameters screen.
At this stage we will not add any parameters to the query. Later, we will modify the query to accept a parameter. Click Next.