Quick Reference — QWebLookup INI File Reference |
|
Item |
Description |
[ … ] |
indicates the Document Type and Field Name for which this configuration represents. |
UDLFile |
represents the specific UDL file to be used to connect to the database for this specific lookup. Each section may reference a different UDL file for connecting to different databases. |
Query |
represents the ‘Select’ statement, without the ‘Where’ clause, for accessing the appropriate database table. |
QueryKey |
is the index field that the lookup will be based off of (added as the ‘Where’ clause portion of the query). |
QueryKeyDBName |
allows you set define the database column name that you intend to use as the key database field if the database column name and the query key document type field are named differently. If the query key has a space in the name, use brackets around the column name. For example, if the document index field and the database column name are the same: QueryKey=column name QueryKeyDBName=[column name] |
KeyType |
represents whether the QueryKey holds numeric values only or string values (a value of ‘1’ represents a string values, ‘0’ is used for numbers). |
PromptNoMatch |
indicates whether or not to prompt the user when no matches are found by the lookup. |
PromptString |
represents the message that will be presented to the user. |
ShowMultMatches |
indicates whether or not a selection dialog should be presented to the user when multiple matches are found by the lookup. |
Field Aliases
To define a Field Alias, where an document index field and the database column that will supply the data value do not share the same name, use the DBColumnNameAlias=CAPSYS CAPTUREIndexFieldName statement. Replace “DBColumnName” with the name of the column in the lookup database. And, replace “CAPSYS CAPTUREIndexFieldName” with the name of document field that will receive the data value.
If QueryType is (1), then the lookup will allow wildcard searches using the % symbol. If QueryType is (0), the wildcard symbol will not be recognized. If a wildcard search is used, be sure to enable ShowMultMatches.
By default the QWebLookup.ini file is located in [C:\Program Files\CAPSYS CAPTURE2\Web].