Expression Builder Options Dialog Box

  • Article

Sets preferences for the items displayed in the ExpressionBuilder. This dialog box appears when you choose Options in the Expression Builder Dialog Box.

Functions

Use these options to change what appears on the String, Math, Logical, and Date functions in the ExpressionBuilder. You can choose to display all of these in the ExpressionBuilderString box, or select only those you want. To select or deselect multiple items, press CTRL as you make your selections.

  • String
    Displays all string functions in the box. All selected string functions will be displayed in the ExpressionBuilder.

  • Math
    Displays all math functions in the box. All selected math functions will be displayed in the ExpressionBuilder.

  • Logical
    Displays all logical functions in the box. All selected logical functions will be displayed in the ExpressionBuilder.

  • Date
    Displays all date functions in the box. All selected date functions will be displayed in the ExpressionBuilder.

    Note   Select individual items by pressing CTRL+left mouse button. Select a consecutive group of items by left-clicking the first item and pressing SHIFT+left mouse button on the last item.

  • All
    Selects all functions in the box so that they all appear as choices in the ExpressionBuilder.

  • Clear
    Deselects all functions in the box so that they don't appear as choices in the ExpressionBuilder.

Field Aliases

These options specify whether and how table or view aliases appear in your expressions.

  • Always Add Alias
    Specifies that the table or view name is always included with fields used in the expression.
  • Add Non-Selected Alias Only
    Specifies that when more than one table or view is open, Visual FoxPro only includes the name of any table or view that is not selected in the Aliases list of the Data Session Window with any of its fields in the expression. Table or view names are not added for tables that are selected in the Aliases list.
  • Never Add Alias
    Specifies that table or view names are not included with any field when you create the expression.
  • Show System Memory Variables
    Specifies whether system memory variables are displayed in the ExpressionBuilder. Turn this option off if you want to see only the system memory variables that have been defined.

See Also

Data Session Window | Expression Builder Dialog Box | Setting Each Control's Print Options | _TEXT System Variable