I got a two dimension array with 50 on 150 elements.
I created a for function to query data and place in in a new array to present in report view dialog:
for i2w = FromH to nRmax1-1
for j2w = 0 to nCmax1-1
LastRunFromEDRDB = EDRDBArr[i2w,0]
RTOfromEDRDB = EDRDBArr[i2w,32]
LastResfromEDRDB = EDRDBArr[i2w,42]
if LastRunFromEDRDB == LastTimeRunDDMMYYFromI then
LastResfromEDRDB = "No data"
RTOfromEDRDB = "No data"
It take up to 1 minute for the function to complete.
I know that working with Array is very fast.
Am i doing something wrong?