LookupEx
Applies to
| Applies | Does not apply |
|---|---|
| Setup DCO | Runtime DCO |
Verification panels that support this variable
| Support this variable: | Do not support this variable: |
|---|---|
Datacap Web Client (VeriFine.aspx) |
Datacap Desktop Datacap Navigator Datacap Web Client (aindex.aspx) |
Description
Specifies a database lookup statement that gets run during verification when the user leaves the field (for example, by clicking or moving to the next field). LookupEx is typically used to populate other fields that are based on current field's value. The structure of the lookup statement is similar to that of the Lookup variable.
Example
The sample LookupEx value looks up the vendor name that is based on the ID in the VendorID field and populates the VendorName field with the result.
Attention: The carriage return in the following example is only
for readability; it is not technically required.
<SQL flist='VendorName' dsn="*/lookupdb:cs">
SELECT Vendor FROM VendorTable WHERE VendorID LIKE '@@VendorID@@%'</SQL>For more information about the LookupEx variable, see the Lookup variable.