Hello, I don't understand how to create array in INFOR LN
select tiapl300.pcfd :pcfd
from tiapl300
left join tiasc200 on tiasc200.pvar=tiapl300.cpva
where tiasc200.pvar =:cpva
hint array fetching
and array size 10000

selectdo
endselect

I need array of dates (pcfd). How to do this?

Hi,

Please post your questions in related forums. Moved to correct forum - "Tools Development"

For creating array, you need to define the array like this -

domain domain_name arr_name(size)

e.g. To create a Date array of size 10 here goes the code -

domain tcdate dates.arr(10)
long i

i = 1
select tdsls400.*
from tdsls400
as set with 10 rows
selectdo
dates.arr(i) = tdsls400.odat
i = i + 1
endselect

Thank you very much!