Skip to main content

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.

    generated description: topfilmsquery1 20111

  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.

    generated description: topfilmsquery inputparameters 20111

  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.

FeedbackOpens in a new tab