pass field values to a variable or an array?

[alexpanjhc]

I have a question in how to passing a field value into a variable

this is my SQL

select A from table X

I want to get the values in A one by one and then use them as varibles.

is there an array or something?

Can you explain how to do it if there is one value or multiple values in A?

Thank you!

[alexpanjhc · Accepted solution]

OK i think i have a solution by using Peek function for single and then a for loop for that multiple values.