Sets preferences for the items displayed in the Expression Builder. This dialog box appears when you choose Options in the Expression Builder dialog box.
Use these options 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.
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.