DB Query only picking up the first selected field
This query is only picking up the first selected field. I proved this by mapping the entire variable to a dummy target and only ever got the first variable. I tried this in the database and I got both variables. I also tried a JOIN instead of the where clause and I also tried renaming the selected fields as in "select test.Name as ENAME", and it still only returned the first field.
DBQuery {select test2.PERS_NBR, test.NAME from EMP.Details test2, EMP.Employee test where test2.PERS_NBR = test.NAME from EMP.Details test2 , $var_ELIG_DBConnInfo , false}
0
-
One quick thing to try would be to set the third argument as true instead of false.
- https://confluence.adeptia.com/display/AS/Using+DB+Function
0
Post is closed for comments.
Comments
1 comment