haider2016

executeSQL

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

 

Regards

Outcomes