UBound($aArray)-1 => Array variable has incorrect number of subscripts or subscript dimension range exceeded

[musahi0128]

Hi guys,

Supposed i have this array

I need to call a function after row 0, row 1, and row 4. Simply put I need to call a function if the data on col 5 next row is different from current data.

My current code is as follow. It works for row 0 and row 1 but it fail for row 4 with error "Array variable has incorrect number of subscripts or subscript dimension range exceeded"

For $a = 0 To UBound($aQuery) -1
  If BitOR($a = UBound($aQuery)-1, $aQuery[$a][5] <> $aQuery[$a + 1][5]) Then
    ; call a function here
  EndIf
Next

I know the error is to be expected, but I can't think of other way to approach my needs.

Any idea how to approach it?

Thanks!

Edited February 27, 2022 by musahi0128
Correction on how to explain my needs

[Nine]

Maybe something like this :

Local $iPrev 
For $a = UBound($aQuery) - 1 To 0 Step -1
  If $iPrev <> $aQuery[$a][5]) Then
    $iPrev = $aQuery[$a][5]
    ; call a function here
  EndIf
Next

 

[ad777]

@musahi0128

this should works without error:

For $a = 0 To UBound($aQuery) -2
  If BitOR($a = UBound($aQuery)-1, $aQuery[$a][5] <> $aQuery[$a + 1][5]) Then
    ; call a function here
  EndIf
Next

 

Edited February 27, 2022 by ad777

[musahi0128]

1 hour ago, ad777 said:

@musahi0128

this should works without error:

For $a = 0 To UBound($aQuery) -2
  If BitOR($a = UBound($aQuery)-1, $aQuery[$a][5] <> $aQuery[$a + 1][5]) Then
    ; call a function here
  EndIf
Next

 

Yes it's eliminate the error but also skip the last step. 
But then this is giving me the inspiration I needed,
Just add one empty row to the array and bam, it works!
Thanks dude, love you hahaha

[Nine]

1 hour ago, musahi0128 said:

Just add one empty row to the array and bam, it works!

It is like applying a band-aid over a headache.   Did you even try my proposal ?  

[musahi0128]

1 minute ago, Nine said:

It is like applying a band-aid over a headache.   Did you even try my proposal ?  

I don't bro, my brain isn't working right right now wkwkwk

After adding an empty row to the array and changing to UBound()-2 it just works for me.

And your proposal seems to count the value backward, is that right ?

[Nine]

Just now, musahi0128 said:

And your proposal seems to count the value backward, is that right ?

Rigth, so what is the problem with that ?

[musahi0128]

2 minutes ago, Nine said:

Rigth, so what is the problem with that ?

Well, i still need it to run forward

[Nine]

Just now, musahi0128 said:

Well, i still need it to run forward

That is a well explained argument.  And probably has nothing with reality.  Let me say, that paradigm is a dangerous tangent against intelligence.  Good luck anyway.

[musahi0128]

1 minute ago, Nine said:

That is a well explained argument.  And probably has nothing with reality.  Let me say, that paradigm is a dangerous tangent against intelligence.  Good luck anyway.

I don't get what you are saying but thanks !

[spudw2k]

@Nine Patient and friendly as usual.