Hi !
How can I save in a array a list of value from a certain table?
I know how to use arrays.

My question is about the 'select' and the way to save the output in a matrix (array).

select t$orno, t$seq, t$date, t$qty
from baantable
where t$date > 01-02-2009

Thank you.

Hi !
How can I save in a array a list of value from a certain table?
I know how to use arrays.

My question is about the 'select' and the way to save the output in a matrix (array).

select t$orno, t$seq, t$date, t$qty
from baantable
where t$date > 01-02-2009

Thank you.

Declare the Arrays.
i = 1 | Initlialize counter
select t$orno, t$seq, t$date, t$qty
from baantable
where t$date > 01-02-2009
selectdo
array1(1,i) = orno
array2(i) = seq
array3(i) = date
array4(i) = qty
i = i + 1
endselect

Well something like this.

Thank you!
It is working now!