Discussion created by haider2016 on Jul 28, 2017
Latest reply on Jul 30, 2017 by beverly

Hi there,


I am stuck with this problem, I applied an executesql to get all iD number of clients using the following:


set variable [$allID; value: ExecuteSQL(" SELECT empID from employees";"";"" )]



I have got a list of all IDs, then I tried to deal with these IDs individually by applying the following instruction:


set field [ $current; GetAsNumber ( GetColumn ($allID;1;char(13) )) ]


the problem is the variable $current got all IDs !


how do I get each ID individually from the resulted list $allID?


any help would appreciated