FindNextDBList

Same as the FindDBList action, except that it locates the next instance.

Syntax

bool FindNextDBList (StrParam)

Parameters

An SQL statement whose result returns a word or phrase, or a list of word or phrases. Smart parameters are supported.

Returns

True, if the word or phrase is on the page. Otherwise, False.

Level

Page level.

Details

This action generates an SQL query against the Lookup database, returning a list of words or phrases that are on the current page. Starting from the location of a previously found word, the search is performed. Initially, the first listed word or phrase from the SQL query is searched for on the page. If there is no match, it will search for the next word or phrase that is returned from the database. The search continues until a match is found or none of the returned words are contained on the page. The location of the found word or phrase is remembered so the result can be used by subsequent actions. The search is case-sensitive.

To improve matching, this action automatically adjusts the search criteria to allow for common character substitutions. For example, if the list includes will and the recognition that is read is wi11, a match still occurs.

Common substitutions include characters: B8, Z2, S5, oO0, and iItl1.

Example

WordFind("Hello")
FindNextDBList("Select LastName from Providers")

In this example, when the first word Hello is found, the LastName list is obtained from a provider table. Then, the first matching occurrence on the page that occurs after the word Hello is found.