Expression Builder Options Dialog Box

  • Article

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

Functions

Enables you to change what appears on the String, Math, Logical, and Date functions in the Expression Builder. You can choose to display all of these in the Expression Builder String 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 Expression Builder.
  • Math
    Displays all math functions in the box. All selected math functions will be displayed in the Expression Builder.
  • Logical
    Displays all logical functions in the box. All selected logical functions will be displayed in the Expression Builder.

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

    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 Expression Builder.
  • Clear
    Deselects all functions in the box so that they don't appear as choices in the Expression Builder.

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 Expression Builder. Turn this option off if you want to see only the system memory variables that have been defined.

See Also

Reference

Data Session Window
Expression Builder Dialog Box
_TEXT System Variable

Other Resources

Dialog Boxes (Visual FoxPro)