Recordset Options

Click the Options button on the Recordset tab to open the Recordset Options dialog box. Configuring filters and host scrolling behavior gives you more flexibility in sorting through recordsets when developing a host application model.

Current record preferences

Configure the options below to describe the properties of the current record in a recordset. The process of finding the current record is also referred to as recordset synchronization. When Host Integrator arrives at an entity with a recordset, it will always indicate the current record is at a record index of 0, which means before the first record. Any subsequent fetch of data will then start with the first record and proceed normally.

In some cases, you may not be primarily interested in fetching data. For example, you may instead want to select a record and navigate to another entity to view or edit details about it. In these cases, the record that the host claims is current may be important information for Host Integrator since the host's current record may not always be the first record. If the host's current record is not always the first record, the model needs to provide the ability for Host Integrator to discover which record is current, so Host Integrator can calculate the number of LineDown or LineUp operations to execute. This is most applicable to character mode hosts; in block mode, the host does not typically designate a current record and Host Integrator can freely choose the record its client desires. Note: The current record definition defined here can also be used for recordset synchronization in procedures.

Excluding records

Configure the following options to create recordset filters that remove unneeded data sent by the host:

Scrolling behavior

Configure the following options to indicate in the model file how the host handles recordsets that overlap between two screens:

If you select the Host overlaps records across screens option, do not select the End of screen is always a delimiter check box under Record size in the Recordset Layout tab.