3.2.2 Field Sequence
Mandatory.
Specify the position of the field relative to other fields in the file.
Field sequence is used to determine the physical order of the fields in the file, or the order of the columns in the table.
Rules
- Sequence numbers must be consecutive.
- The sequence number is automatically assigned when a field is added. Sequence number is updated when the order of the fields is updated in the list of fields.
Tips & Techniques
- Field sequence is not related to 3.2.3 Field Key Position . However, the key fields are typically the first fields listed in the file.
- Field sequence is important when templates are used to generate RDML code. By default, fields are listed in the physical order in the file. Generally, the most important fields will be grouped as the first fields in the file.