We have SQL access to the search database and it's easier than via web services.
Using Lookup variable https://www.ibm.com/docs/en/datacap/9.1.9?topic=variables-lookup works fine even if we are filling multiple fields by selection. The disadvantage is the inability to format the columns in the results window and the fact that all columns are displayed here, even those that the user does not need to see, such as ID.
For a small dropdown with values, the SELECT variable is better https://www.ibm.com/docs/en/datacap/9.1.9?topic=variables-select. The documentation says: Note that you can populate multiple fields simultaneously (see the Lookup variable for an example). This doesn't work for us. Using the simplified example from the documentation:
<SQL flist='Vendor,Vendor_Number' dsn="*/lookupdb:cs">SELECT VendorName,VendorID FROM VendorTable WHERE VendorName LIKE '@@Vendor@@%'</SQL> in the Lookup variable, so the field is filled after selection Vendor (in which the variable is) and the field Vendor_Number. If we just rename the variable to SELECT, only the Vendor field is filled, but not the Vendor_Number. Are there any other conditions so that additional (hidden) fields can be filled with the SELECT variable? We want to use it for an internal ID, similar to how it is possible to have another displayed and stored value with a DICT variable and a dictionary.
We are using IBM Datacap 9.1.9 iFix 04 and Datacap Navigator.
------------------------------
Martin Pistora
------------------------------