Applies | Does not apply |
---|---|
Setup DCO | Runtime DCO |
Support this variable: | Do not support this variable: |
---|---|
DotEdit Taskmaster Web (VeriFine.aspx) |
Taskmaster Web (aindex.aspx) |
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.
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.
<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.