Scroll Down (Recordset Termination Options Dialog Box)

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 termination criteria define a set of behaviors that you set to determine how the Host Integrator knows 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, for example Scroll operation results in same recordset data is first,and so forth.

If you attach an event handler to the recordset that has an Is Terminated event implemented, a lightning bolt (lightening ) displays 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.

This option Does this....
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 screen after the Scroll Down operation contains the specified number of blank records.
Screen contains __ repeated record(s) The screen after the Scroll Down operation contains the specified number of identical records.
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.
Max number of Page Down operations This value sets the maximum number of Page Down operations that are executed before an error message is sent. The default number of operations is 1000, which in normal usage should never be reached, but setting a maximum value ensures that if a termination option on the same page is in error, an endless loop cannot occur.

Exclude records on last screen

Use these options to determine how Host Integrator will handle recordset data when it recognizes that it has reached the last page in a recordset.

Select Exclude records repeated from previous screen to stop Host Integrator from returning records from the last page, if they are identical to those records on the previous page.

The following options specify where you want Host Integrator to stop returning data from the last page in a recordset. If you select more than one of these options, Host Integrator stops returning data after one of the options is satisfied.

This option Does this....
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 option and click Edit to open the Condition Edit dialog box. Using this dialog box, construct a logical statement describing a condition to indicate where to stop returning records.
Related Topics
Bullet Troubleshooting recordsets
Bullet How to add a recordset