Versions Compared

Old Version 2

changes.mady.by.user Rodrigo Rivero

Saved on

compared with

New Version Current

changes.mady.by.user user-eb51a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Important Observations

  • From your results window, you could have removed the Department code from your query now that you display the associated descriptions.
  • When you create a query, you must first choose a file to be the primary file. In this case, the primary file is the Employee file. You can easily identify the primary file because its name is displayed in the title bar of the Selected File area.
  • Once a file has been "selected" by double clicking on its file name, all the fields in this file and the files that are related to this file are displayed. Related files are defined in the Repository on the host using LANSA's Access Route Definitions. Related files are indented beneath the selected file and represented by this icon Image Removed   Image Added if closed, or this icon Image Removed   Image Added if opened.
Tip

Tips:

  • You have just constructed a join query which spans two files without having to specify any fields to join the files together. LANSA Client took care of the join logic for you.
  • If you want to see the fields which are used to join the files, select the Field Conditions command from the Options menu. The Conditions list box in the Field Conditions dialog box shows you the fields which are used to join the files.


Image Removed
[ Image Removed |../../index.htm#lansa/lceeng01_0260.htm]Image Added