Using value from previously loaded table to filter subsequent query
Hello. I am trying to use OBJECTID, and CHANGENR as filters for the next query. In debug mode, both vCHANGENR and vOBJID are returning nulls. My script is below. I can't figure out why I am getting nulls.
CONCAT(Chr(39)&OBJECTID&Chr(39),',') as OBJID
LET vOBJID = OBJID;
LET vCHANGENR = CHANGENRID;
LIB CONNECT TO 'SAP';
INNER JOIN LOAD
WHERE OBJECTCLAS = 'VERKBELEG' AND TABNAME = 'VBEP' AND FNAME = 'EDATU' AND OBJECTID IN('$(vOBJID)');