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