Step 1 Open an Existing Query

Step 1. Open an Existing Query

1.  Select the File menu choose the Open command. Alternatively, you could select the Open an existing query icon on the Tool Bar, or use the accelerator key combination (Ctrl + O) that is shown beside the Open command.

     The Open Query dialog box is displayed.

     The Open Query dialog box contains a list of existing LANSA Client queries.

2.  Select the LCSample.LCQ, the Sample Query.

3.  Press the OK button to open the Sample Query.

     The Query window showing the Sample Query is displayed.

     Note that in this window, the field and file names are displayed beside their field and file descriptions. To remove these names, from the Options menu, select Display Object Names and click on it to remove the tick. Your Query window will now look like this:

     In the Query window, you will see the "definition" of the query that you have opened. That is,

     in the Selected File area:

• the Name of the primary file selected for the query, in this case, the Sales History file.

• all the fields in the Sales History file.

• the fields selected for the query. They have a tick over their icon.

     in the Selected Fields area:

• the fields that have been selected for this query.

     in the Defined Links to Queries area:

• the Sample Query. Only this query is displayed as there are no linked queries.

     As you can see, the Sample Query will retrieve the Sales History for all Products for January, February and March.

4.  Now go to Step 2. Attach Selection Conditions to the Query.