analytical scoreboard - Resolved -

[Silvio.Falconi]

in an array except a series of numbers from zero to 90 from the second element onwards up to 55 fields.
each time I save the array record


However, it is possible that there are all zeros in the array record




For a sample after the number 21 I not have I have no other number but only zeroes

how can i check when i have all array elements the number 0 and not the other numbers?

[Antonio Linares]

AScan( aData[ row ], { | n | n != 0 } ) == 0

[Antonio Linares]

Thanks to Rao, as in first column you have a number:

AScan( aData[ row ], { | n | n != 0 }, 2 ) == 0

[Silvio.Falconi]

Thanks to Rao, as in first column you have a number:

AScan( aData[ row ], { | n | n != 0 }, 2 ) == 0

thanks run ok

[Silvio.Falconi]

Thanks to Rao, as in first column you have a number:

AScan( aData[ row ], { | n | n != 0 }, 2 ) == 0

Antonio the command not run ok

I explain you
If I insert on my cicle

Do While !oDbf:Eof()

aadd(aTab ,{................})



If AScan( atab[ nrow ], { | n | n != 0 }, 2 ) == 0


exit
else

nrow:=nrow+1
nrit:=nrit+1
oDbf:Skip(-1)
Endif

Enddo


it stop at 65 row as you can see here





But I have a number until 121 row



How I can resolve ?

[Antonio Linares]

Dear Silvio,

I need a better explanation from you about what you need to be able to help you

[Silvio.Falconi]

Dear Silvio,

I need a better explanation from you about what you need to be able to help you

ascan must check if in the horizontal line there are still numbers, if there are not the while loop must end, however it is possible as in this case that the number of finds after n lines

On picture you can see the Number 15 on row 121, It mean the Number 15 have a delay of 121 extraction

But what does the analytical scoreboard procedure do? the procedure starts from the last record and in the first line (delay 0) puts all the 55 numbers out. From the second line (delay 1) he inserts the number he finds in the penultimate record but if a number is the same in the previous line / lines he does not write it but puts a zero. 0 (zero). Then the procedure continues with the third to last record omitting the numbers found in the previous lines. And so on until he has no more numbers to show. In our case the number 15 has been placed in line 121 this means that the number 15 has a delay of 121 extractions. I don't know how to check this. In the lot history it happened that a number had 299 draws late.