Scroll Down (Recordset Termination Options Dialog Box)

Use this tab to define:

how Host Integrator is to recognize that it has reached the last page of a recordset (Scroll termination criteria)
how Host Integrator is to filter recordset data when it recognizes that it has reached the last page in a recordset (Exclude records on last screen)

Note: In order for these configured options to take effect, you must define a page down operation for the selected recordset on the Operation tab. To view an example of a page down operation, open the Pine model and select the AddressBook entity.

Scroll termination criteria

The options in this group define a set of behaviors that a host application might use to indicate the end of a recordset. The options you select from this set are defined as "termination criteria," which let Host Integrator know that it has reached the end (last page) of a recordset. If you select multiple termination criteria, Host Integrator assumes the end of the recordset is reached as soon as any one of the selected criteria is satisfied. The criteria are tested in the order they are listed in this dialog box—Scroll operation results in same recordset data first, etc.

If you attach an event handler to the recordset that has an Is Terminated event implemented, a lightning bolt ( ) is displayed to the left of this option. This is a reminder that the event handler may include logic that overrides or extends any of the settings you configure below.

Scroll operation results in same recordset data—The records displayed after the Scroll Down operation are the same as before the operation.
Scroll operation results in entity change—The Scroll Down operation triggers the recognition of a new entity.
Screen contains __ blank record(s)—The recordset contains the specified number of blank records after a Scroll Down operation.
Screen contains __ repeated record(s)—The recordset contains the specified number of identical records after a Scroll Down operation.
Screen contains pattern—The specified pattern is present in on the screen after the Scroll Down operation. The Learning to Use Host Integrator tutorial employs this strategy to recognize the end of the AccountList recordset (in the Terminating the page-down operation section).
Screen has condition—Select this check box and click the Edit button to open the Condition Edit dialog box. Use this dialog box to construct a logical statement that defines the end of a recordset.

Exclude records on last screen

Use the options in this area to specify how Host Integrator is to filter recordset data when it recognizes that it has reached the last page in a recordset.

Exclude records repeated from previous screen—If some of the records on the last page in the recordset are identical to records in the previous page, Host Integrator should not return them.

The remaining three filter options specify where Host Integrator should stop returning data from the last page in a recordset. If more than one of these options is selected, Host Integrator stops returning data after any one of the options is satisfied.

Read until __ blank record(s) are found—No records are returned after the specified number of blank records is found.
Read until pattern—No records are returned after the specified pattern is found.
Read until record with condition—Select this check box and click the Edit button to open the Condition Edit dialog box. Use this dialog box to construct a logical statement that describes a condition that is to indicate where to stop returning records.