For Loop

[stick3r]

For $i = 1 To UBound($arrTotal) - 1

    Global $strReference = $arrTotal[$i][0]
    Global $strCurrency = $arrTotal[$i][1]
    Global $strAmount = $arrTotal[$i][2]
    Global $strStartDate = $arrTotal[$i][3]
    Global $strEndDate = $arrTotal[$i][4]

    Global $strGuarantees = "Reference: " & $strReference & @CRLF & _
                "Amount:        " & $strCurrency & " " & $strAmount & @CRLF & _
                "Term:      " & $strStartDate & " " & "-" & " " & $strEndDate

                 $strGuarantees = $strGuarantees & @CRLF

    MsgBox(0,0,$strGuarantees)
Next

MsgBox(0,"All Guarantees",$strGuarantees)

Hi, I have this code, which works just fine, I have 10 rows of array, I get 10 different MsgBox'es from inside the loop, but I want them to stack on each other and with every new Loop to have first $strGuarantees[1] +  $strGuarantees[2].... and in the MsgBox(0,"All Guarantees",$strGuarantees) to see all 10 $strGuarantees. Now I get only the last $strGuarantees in MsgBox(0,"All Guarantees",$strGuarantees).

Where am I doing wrong?

[Melba23]

stick3r,

So why did you hijack an 11 year old thread to post this? In future, just open a new thread - as I have now done for you.

M23

[stick3r]

Hi,

I thought it was not worth creating new thread for such question and just use some existing one.

 

[AndyG]

Hi,

one solution could be

$strGuarantees=""

For $i = 1 To UBound($arrTotal) - 1

    Global $strReference = $arrTotal[$i][0]
    Global $strCurrency = $arrTotal[$i][1]
    Global $strAmount = $arrTotal[$i][2]
    Global $strStartDate = $arrTotal[$i][3]
    Global $strEndDate = $arrTotal[$i][4]

    Global $strGuarantees = $strGuarantees & "Reference: " & $strReference & @CRLF & _
                "Amount:        " & $strCurrency & " " & $strAmount & @CRLF & _
                "Term:      " & $strStartDate & " " & "-" & " " & $strEndDate & @crlf

    ;MsgBox(0,0,$strGuarantees)
Next

MsgBox(0,"All Guarantees",$strGuarantees)

 

[FrancescoDiMuro]

@stick3r

Declaring a variable ( or more ) in a statement, or in a loop like in this case, will destroy it and re-create it everytime.

This means that, everytime your For...Next loop does a cicle, your variable is recreated, and you can only have the last value of ypur array, since it has no more loops to do.

You want to display all of them, right?

Just put the declaration of $strGuarantees outside the loop, and you're done

[mikell]

The name of what you want is : concatenation - probably 

$allGuarantees = ""   ; declare the string

For $i = 1 To UBound($arrTotal) - 1
    $strReference = $arrTotal[$i][0]
    $strCurrency = $arrTotal[$i][1]
    $strAmount = $arrTotal[$i][2]
    $strStartDate = $arrTotal[$i][3]
    $strEndDate = $arrTotal[$i][4]

    $strGuarantees = "Reference: " & $strReference & @CRLF & _
                "Amount:        " & $strCurrency & " " & $strAmount & @CRLF & _
                "Term:      " & $strStartDate & " " & "-" & " " & $strEndDate

                 $allGuarantees &= $strGuarantees & @CRLF & @CRLF  ; concatenate using &=
Next

MsgBox(0,"All Guarantees",$allGuarantees)

 

[stick3r]

Thank you, all good now!