Navigator User Guide

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Viewing Records and Fields

You can view one or more records in a data map, and fields in each record.

Each record appears in its own

Record

window. A

Record

window displays the record name and the fields in the record.

To view records and fields:

Open the data map.

On the

Data Map

tab in the

Resource Explorer

, complete one of the following actions:

To view a single record, double-click the record.

To view multiple records, each in a separate

Record

window, right-click each record and click

Explore

The

Fields

tab in a

Record

window displays the record name and the following information for each field:

Field name

Datatype

Precision, scale, and length values, in parentheses

If the field is defined as an array, the value

ARRAY

followed by the number of elements in the array

The decimal offset of the field within the record

The hexadecimal offset of the field within the record

The

Expr(n)

tab in the

Record

window displays any user-defined fields. The n variable indicates the number of user-defined fields.

Each row on the

Expr(n)

tab contains either a field definition or the assignment of a value to a defined field.

The following table describes the columns that the

Expr(n)

tab displays for each field:

Column	Description
Field status indicator	Indicates the status of the field. The options are: Check mark . The field is valid. X . The field is not valid. The comment in the Validation column describes the type of error that the field contains.. Arrow . A new field is selected, after selecting one of the Add Field menu commands.
Name	The user-defined name for the field.
Type	The datatype of the field.
Precision	The precision of the field.
Scale	The scale of the field.
Length	The length of the field.
Phase	Indicates the type of database communication for the user-defined field. For example, if a field is defined with a phase of R, its expression is not recalculated when the database is being written to. The options are: R . Read. W . Write. RW . Read and write.
Expression	Any expression defined for the field.
Validation	If you click Validate in the Expression Editor dialog box, the Validation column displays the validation message.

To sort or delete fields on the

Expr(n)

tab, perform the following actions:

To move a field up or down in the window, right-click a field and click

Move Field Up

Move Field Down

To move the completed fields to the top of the list, right-click anywhere on the

Expr(n)

tab in the

Record

window and click

Organize Fields

To delete a field, right-click a field and click

Delete Field

To show or hide columns that define the datatype attributes for fields on the

Expr(n)

tab, right-click anywhere on the

Expr(n)

tab in the

Record

window and click one of the following commands:

To show or hide the

Type

Precision

Scale

, and

Length

columns, click

Hide Type Columns

Show Type Columns

To show all columns and restore all columns to the default width, click

Restore Columns

Data Maps

Adding a User-Defined Field to a Record

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

Viewing Records and Fields

Viewing Records and Fields