Has anyone been able to get the LookupEx Field variable to execute?
I currently have it added to a field with both a Lookup and LookupEx variable. The Lookup field creates the Hyperlinked Label name for the Field, and executes appropriately. Once a row is selected from the resulting datagrid, the fields in the flist parameter are successfully populated. Once I leave the field, tab through it, nothing additional happens or is logged.
<SQL flist='DPSNIB,DPSEmpName,DPSGender,DPSDateOfBirth,DPSDepartmentNumber,DPSDepartmentDesc,DPSJobCode,DPSJobTypeDesc,DPSEmpStatusCode,DPSEmpStatusDesc,DPSCurrentDate,DPSEmpDate' dsn="DSN=DPS;User ID=********;Password=********">SELECT NIBNO,EMPNAME,GENDER,DOB,DEPTNO,DEPTDESC,JOBCODE,JOBTYPDESC,EMPSTATUSCD,EMPSTSTDESC,CURRDATE,EMPDATE FROM FILENET.DPS100V1 WHERE EMPNO LIKE '@@DPSEmpNo@@%'</SQL>
As an FYI, the reason I don't just list ALL the parameters in the original flist is actually another issue with Lookup, which causes an ADOSelectXML error when too much data is returned.
I know I could modify the existing custom Panel, but I would prefer to utilize it this way to be able to leverage the other environments (Web / Navigator) for essentially free.
Any help would be appreciated.