FindDBList_InZone
Locates a word that matches a word from the current field.
Syntax
bool FindDBList_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 on the page. Otherwise, False.Level
Page or 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. The search is performed from the first word of the current field. Initially, the first listed word or phrase is searched for in the field. 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
FindDBList("Select LastName from Providers")This example obtains a LastName list from a provider table and finds the first matching occurrence on the page.