FindNextDBList_InZone

Syntax

bool FindNextDBList_InZone (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 in the field. Otherwise, False.

Level

Field level.

Details

This action generates an SQL query against the lookup database, returning a list of words or phrases that are in the current field. 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.

To improve matching, this action automatically adjusts the search criteria to allow for common character substitutions.

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

Example

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

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