Page 1 of 1

analytical scoreboard - Resolved -

Posted: Tue May 17, 2022 10:46 am
by Silvio.Falconi
Image


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


Image

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?

Re: analytical scoreboard

Posted: Tue May 17, 2022 11:47 am
by Antonio Linares
AScan( aData[ row ], { | n | n != 0 } ) == 0

Re: analytical scoreboard

Posted: Tue May 17, 2022 11:56 am
by Antonio Linares
Thanks to Rao, as in first column you have a number:

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

Re: analytical scoreboard

Posted: Tue May 17, 2022 12:04 pm
by Silvio.Falconi
Antonio Linares wrote:Thanks to Rao, as in first column you have a number:

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


thanks run ok

Re: analytical scoreboard

Posted: Wed May 25, 2022 5:17 pm
by Silvio.Falconi
Antonio Linares wrote: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

Image



But I have a number until 121 row

Image

How I can resolve ?

Re: analytical scoreboard

Posted: Wed May 25, 2022 9:56 pm
by Antonio Linares
Dear Silvio,

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

Re: analytical scoreboard

Posted: Wed May 25, 2022 11:31 pm
by Silvio.Falconi
Antonio Linares wrote: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.