Name, Start, End, and Key (Recordset Fields Tab)
Before you can define a field on a recordset, you need to add fields
to your recordset.
Note: If the size of a record in a recordset is not consistently a fixed
number of rows, you can create variable records
in a recordset. Variable records enable you to dynamically access records that
change in size throughout your host application. Using the Recordset
Layout tab, configure a distinguishing characteristic of a record in a recordset
and then, using the Recordset Fields
tab, identify certain record fields in a recordset that are unique.
To add a field to a recordset:
- Select an area within the recordset on the terminal screen that contains
specific data and click the New Field
Note: By default, a name and the start and end offsets of the field
are provided by the Design Tool. To change the name of the field, place
your cursor in the Name text field and type a new name.
- To delete the field, place your cursor within the field definition in the
Entity window and click the Delete
Use the following options to further define the field you just created:
- The name of the field.
- The start offset within a field. By default, the Design Tool provides the
start coordinate of the field you have selected. Note: This is not
a position on the terminal screen but rather a position within the record.
Example: If a terminal screen is 80 columns wide and a record has two
rows, the Start position on the second row will be 1 rather than 81.
- The end offset within a field. By default, the Design Tool provides the
end coordinate of the field.
- Select this check box if the name of this field returns one unique record.
If you mark multiple fields as a key, the combination forms a key that appears
in the exported documentation to aid
the API developer in fetching specific pieces of data.
To create variable records in a recordset:
- Add a recordset to your model.
- On the Recordset Layout tab, select Variable under Record
- Select an option from the Delimit by box.
For example, select <Any text> and then specify the start
and end column of the text that appears in the first row of a recordset.
- Click the Advanced Delimiter Properties
button to open the Advanced
Recordset Delimiter Properties dialog box.
If you have selected a delimiting property that is also data in the recordset,
like the <Any text> option described above, configure the options
in this dialog box.
- Click the Recordset Fields tab, and add fields
to your recordset.
- On the last field of the recordset, delete the column number in the End
box and type the letters eor, which notifies the Host Integrator that
this is the end of the variable record that you've created.