Inspecting Reference Queries

When you have inspected your collection class queries, the Reference Query sheet of the External Schema Wizard, shown in the following image, then enables you to inspect your reference queries.

An SQL query is generated for each reference in your external database schema. An ORDER BY clause is generated for dictionary and array collections only.

The Classes list box at the left of the sheet lists all classes (that is, From classes) defined for this external database schema.

To inspect a generated reference query

  1. In the Classes list box, select the class whose reference query you want to view.

    The rows of the References Table are grouped into sections, with a separate section for each To class. Each row of the table displays the name of the reference, the From Table(Columns), and the To Table(Columns) of the external relational database. On the far right is a Details button.

  2. In the Reference Name list in the References Table, select the reference to the class whose SQL query you want to view. You can view the SQL query only; you cannot tailor a reference query.

    The SQL Query frame at the upper right of the sheet then displays the entire SQL query that was generated for the selected class reference. You can view the SQL query only; you cannot tailor a reference query.

  3. To view the definition of the selected reference, click the Details button at the right of the sheet.

    The External Schema Wizard Relationship dialog is then displayed in read-only mode, to enable you to view the definition of the selected reference. To edit the relationship, return to the Define References sheet.

    For details, see "Using the External Schema Wizard Relationship Dialog" and "Adding References to a Class", respectively, earlier in this chapter.

  4. Repeat steps 1 through 3 for each reference whose query you want to inspect.

  5. Click the Next > button when you have inspected all required reference queries.

    Alternatively, click the Close button to close the wizard.

When you click the Next > button, the External Schema Wizard then enables you to confirm that you have finished defining your external database schema.