Fields

Fields are added to blocks on entities.  They may or may not reference a column in the database.  Fields are used for a multitude of purposes as they can be defined as a variety of types and displayed in a variety of ways.

Types of fields include:

  • Currency

  • Date (Only)

  • Date and Time

  • Numeric

  • Text

Types of fields for Converters, Data Exchanges, Spreadsheets, and XML documents include:

  • Text

Report fields can be displayed in the following formats:

Screen and Parameter Form fields can be displayed in the following formats:

Bread Crumb blocks on screens can have the following:

QBE blocks on screens can also have the QBE Column Selector.

See Also

Adding Fields

Adding Labels

Default Values for Fields

Formulas

Bread Crumb Fields

Button Fields

Chart Fields

Checkbox Fields

Client Date Fields

Client Date Time Fields

Converter Fields

Data Exchange Fields

Default Button Fields

Image Fields

Label Fields

Object Fields

Option List Fields

Password Fields

QBE Column Selector

Report Fields

Reset Button Fields

Spreadsheet Fields

Text Fields

Text Area Fields

XML Document Fields

Upload File Fields

Database Function Calls

Global Values and Variables

Obtaining Field Values

Passing Values between Entities

Property Definitions

Adding Fields

  1. In the Explorer Tree, locate the object to which you wish to add a field.  

  1. There are options in adding a field to the block at this point.

  1. The Adding New Fields screen will be displayed.

  2. A list of the columns from the select statement or the Xephr service will be displayed.

  3. Set the Key Required flag to the desired setting.  This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on.  The Next button cannot be pressed until the key column is selected or this flag is set to off.

  4. For each column, indicate whether the column is a primary key for the view by setting the Key flag to on or off.  
    To set the Key flag for all displayed columns, left-click once on the gray Key column header.

  5. For each column, indicate whether the column will be included as a field on this block by setting the Field flag to on or off.
    To set the Field flag for all displayed columns, left-click once on the gray Field column header.

  6. For each column, indicate whether a label should be created for the field on this block by setting the Label flag to on or off.
    To set the Label flag for all displayed columns, left click once on the gray Label column header.

  7. For each column, in the Display As pop-list, select the desired setting to display the data for this column.  Choices are:

  1. For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.  

  2. For each column, in the Format pop-list,  select the format mask for this field from the list of pre-defined format masks.  

    Date fields must have a format mask entered.  Format masks can only be applied to date and numeric fields.  

    For more information, see the Format Masks section.

  3. Click on the Next button in the bottom right of the screen to continue.

  4. The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be displayed on the block.

  5. Press the Next button at the bottom right of the screen to continue.

  6. See the appropriate section to modify the new field to be the desired type and display format.

Adding Labels

  1. In the Explorer Tree, locate the object to which you wish to add a label.  

  1. To add a label, right-click on the block, hold your cursor over the Create option, and when the sub-menu is displayed, left-click on the Label option.  

  2. The Adding New Labels screen will be displayed,

  3. To add a new label, click on the Add button.

  4. In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.

  5. Repeat until you have entered all desired labels.

  6. To delete a label that you have created, click on the desired label and press the Delete button.

  7. When all desired labels have been entered, click on the Add Labels button on the bottom right of the screen.

  8. The labels will be added to the block.  

Xephr is a registered trademark of NDS Systems, LC.

Copyright © 2007 NDS Systems LC.