Setting Activity text field with recordset
Hi,
I am trying to set activity text field in the Notes tab with the multiple results from SQL query however I get only top result in my case 1 DocNum but I have more than one DocNum
The code I use set ($[$25.0.0]|SQL:SELECT T0."DocNum",T0."DocDate" FROM ODLN T0 WHERE T0."U_ConComInv" ='Y' and T0."CANCELED" ='N' and ifnull(T0."U_ConComInvComplete",' ') <>'Y' and T0."CardCode"=$[$9.0.0]);
I tried create activity UF and also I get one result from my query.
Is there any way to do it?
Thank you
Kate
0
Please sign in to leave a comment.
Comments
0 comments