View Menu in NamoUtil

Seek
Browse
Edit
Browse/Edit
Select Fields
Set Filter
Set Index Order
Set Scope
Table Structure
Clear Screen

 

Seek

After choosing an Index with the Set Index Order in this same menu, you can search immediate for a key in the table.

Browse

Displays the contents of the current table or view in a Browse window, and allows you to examine and make changes to data in the table or view.
This command is available when you open a table or view in Browse, Edit, or Append Mode view.

When you are browsing a table in the Browse window, you can view records in two different modes, Browse and Edit. You can switch modes by choosing Browse, Edit or Browse/Edit from the View menu.

Note   When you open a table using Open from the File menu, you have to choose Browse <table> from the View menu in order to see the table.

To select fields, click a cell or press TAB, ENTER, or the arrow keys. Move a column to a new position by clicking on the field name, dragging the column where you want it, and releasing the mouse button.

To enter a null value in a field that accepts null values, press CTRL+0. As long as a field that contains a null value remains active, nothing is displayed in it.
After you activate a different field, the one containing the null value will display the string defined by the SET NULLDISPLAY command (for example, ".NULL.")

If you choose Append from Table, Append new record, the Browse window adds a new, blank record.
When you fill in the new record, the Browse window automatically adds another new record.

Note   In some cases, if you browse a table or cursor generated by a crosstab query, the field names start with a character and a dash, indicating the data type of the field.
For example, a numeric field starts with N-.

Select Fields

With this option you can select the fields to edit/browse. 
Note You can also specify a user defined field with syntax included. This option will open the expression builder to create a selection-criterion for the current table open using regular syntax. Some of the syntax options are described here below.

Set Filter

This option will open the expression builder to create a selection-criterion for the current  table open using regular syntax.
Below you will find the description of the available selection options.

The filter-setting will filter out records which match the friterion and will act like they are the only records in the table.

Allows you to create and edit expressions. An expression can be as simple as a field name or as complex as a calculation involving immediate IF functions, concatenations, and data type conversions. The main purpose of the Expression Builder is to facilitate the creation of expressions by providing you with lists of appropriate options each step of the way. This dialog box can be accessed from designers, windows, builders, and wizards.

To create an expression, you can type it directly into the expression box, or you can select items from the functions drop-down lists in the dialog box to have NamoUtil paste them into the expression box for you.

You might find some of the following functions useful when manipulating strings in expressions.

If you want to Use this function
Remove leading and trailing blanks from character expressions ALLTRIM( )
Remove leading blanks LTRIM( )
Remove trailing blanks RTRIM( )
Add specified characters to the left, right, or both sides of a string PADL( ), PADR( ), PADC( )
Work with parts of a character string for comparisons SUBSTR( )
Use a specified number of characters starting with the left of a string LEFT( )
Use a specified number of characters starting from the right of a string RIGHT( )
Change uppercase to lowercase, or lowercase to uppercase UPPER( ), LOWER( )
Convert a string to initial capitals PROPER( )
Have a numeric field interpreted as a character string STR( )


You will find the following options:

Functions
Contains list boxes of four function types. When you select a function from one of the four types, NamoUtil automatically pastes it into the expression box. When you are building expressions for remote views, NamoUtil lists only the functions specific to the target back-end data.
String
Lists available character string functions.
Logical
Lists available logical functions.
Math
Lists available math functions.
Date
Lists available date and time functions.
Expression
Displays the expression that you are creating or editing.
Fields
Lists the fields in the current table or view.
To paste a field into the Expression box, either double-click the field or select the field and press ENTER.
To display fields from a different table, select a different table in the From Table box.
From Table
Lists tables and views that are open. Select a table or view to update the Fields box.
Variables
Lists system memory variables, arrays, and memory variables that you have created.
To paste a variable into the Expression box, either double-click the variable, or select the variable and press ENTER.
Verify
Validates the syntax of the expression in the expression box if the corresponding table is open. If the expression is valid, "Expression is valid" is displayed in the status bar. If it is not valid or if the corresponding table is not open, Visual FoxPro displays an error message. This option is not enabled for remote views.

Note   If you include a user-defined function call in the expression, Verify will indicate an error, but there will not necessarily be an error when the expression is evaluated at run time.

Options
Displays the Expression Builder Options dialog box, in which you can set preferences for the Expression Builder.

 

Set Index Order

Use of an Index will show the table-data in a chosen order. Choose from the preset indexes on the table or define your own specific index.
The Index-field specification shows what fields are used for the chosen index.
Just select an Index, but do not create a new index on a table which is in use by others.

Set Scope

With the Scope-option you can specify what elements of the table you want to view.

Table Structure

This option gives an overview of all fields in the active table with specified length and field-type.

 

Clear Screen

Clears the screen.

back to the top