FindDBList
Locates a word that matches one of a list of words that are obtained from a SQL query.
Syntax
bool FindDBList (StrParam)Parameters
An SQL statement whose result returns a word or phrase, or a list of words or phrases. Smart parameters are supported.Returns
True if the word or phrase is located on the page. Otherwise, False.Level
Page or field level.Details
This action issues an SQL query against the lookup database, returning a list of words or phrases that will be located on the current page. The search is performed from the first word of the current page. Initially, the first listed word or phrase is searched for on the page. If there is no match, it will search for the next word or phrase returned from the database. This 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 will be 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 read "wi11", a match will still occur.
Common substitutions include characters: B8, Z2, S5, oO0 and iItl1.
- Example
FindDBList("Select LastName from Providers")This example gets a list of last names from a provider table and find the first matching occurrence on the page.