Saving a statement for later use

The statements you create can be saved and recalled for use with other calculated representation or calculated field rules. The statements are saved as query files, which place the SELECT, FROM, and WHERE information on separate lines, as shown below:

, US_UrbanAreas
POP1990 = US_UrbanAreas.POPULATION
  1. Start ArcMap.
  2. If necessary, load data in the map.
  3. Define the SQL statement.
  4. Click Save.

    The Save As dialog box appears.

  5. Navigate to the directory in which you want to save the SQL statement.
  6. Type a name in the File name text box.
  7. Click Save.

    The Query Builder dialog box appears.

  8. Click OK.

    You can clear the contents of the SELECT OBJECTID and WHERE fields by clicking Clear.