Record Properties - Fields

 

Record Properties

Expand/Collapse all Show/Hide All

Record Type

This field displays the selected record type. This field can only be viewed.

 

Field

Enter a source field. If the source is ODBC, a Lookup feature is available; click the Lookup button to list available fields.

 

Start

Type the starting position within the data field to evaluate. The default value for this field is 1.

 

Length

Type the length of the portion of the data field to evaluate.

 

Perform Logic

Select this check box to add perform logic to be executed before or after record write, without specifying a record selection. These perform logic statements will be used in addition to any perform logic specified for a record type. If a default perform logic is assigned to the import file, a standard record type with a "perform logic" setting will be created automatically. No other fields are available when this check box is selected.

 

Relation

Select the relationship used to evaluate the record type.

The Search option allows you to specify part of the field for which to search. The Program option allows you to specify a ProvideX program name to be run to validate the record.

Expand/Collapse item Example - Using the Search option

You could select that a record is an item record when the imported field contains XYZ. If the text XYZ is contained anywhere within the data field, the record is identified.

 

Value

Type the value to use to identify the record type. If the data stored in the source record compares to the value entered in the Value field using the relationship specified, the record will be imported.

 

List

Enter the list of values to be used for the List relation. If the data stored in the source record is equal to one of the values in the list, the record will be imported.

 

Start/End

Type the starting and ending values to use for the Range relation. If the data stored in the source record is equal to or within the range of the two values, the record will be imported.

 

Program

Enter the name of the external program to execute.