Database Interface (Fields)
This property (also known as the field interface) determines how data in the field is physically stored in the database.
The value can be a field interface code or a reference to a Modeled Field Interface. If no value is specified, Uniface uses a default interface code based on the Data Type.
|
Value |
Description |
|---|---|
| FieldInterfaceCode |
A code that combines a variety of information such as packing code and field length, numeric decimal and scaling options, and subfield definitions. For more information, see Field Interface Codes .
|
@LIB::ModeledInterfaceName
|
Reference to a Modeled Field Interface. |
Description
The field interface code usually represents the packing code (DBMS data type mapping) and field length. For example, for String fields, the default is C40 (Character field, 40 characters in length).
The property may also specify subfields, variable length fields, or database I/O translation. Normally, you do not need to consider these definitions. They are intended only for existing databases that support these features.
Some packing codes are associated with a default display format. If this format is not appropriate, you should explicitly define one in the Field Layout.
Because many fields will have the same field interface, it can be useful to create Modeled Field Interfaces and reuse them in field definitions. For example, you could a define a Modeled Field Interface to be used for currency values, and reuse that in every field that stores a price, invoice total, salary, or other currency amount.
