Friday, May 5, 2017

Using lookup input ports in SQL Override for non-cached lookup

If you need to use lookup input ports in the SQL Overrride for non-cached lookup, you need to use ?name? notation, eg.:

SELECT LAST_NAME FROM EMPLOYEES WHERE EMP_CODE = ?in_emp_code?