Sign in to follow this  
Followers 0
joeloyzaga

read an array using a variable as the index number

4 posts in this topic

I want to read down an array using a variable as the index but I keep getting

Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

is there a simple way? using Ubound,Lbound?

Joe

Share this post


Link to post
Share on other sites



We need to see your code.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

global $arraymax= 10, $arraydatamax= 3;[0..9][0..2]
main()
func main()
    local $array[$arraymax][$arraydatamax]
    ;use index variables to set array's data
    for $i= 0 to $arraymax-1
        for $ii= 0 to $arraydatamax-1
            $array[$i][$ii]= $ii
        next;ii
    next;i
    arrayout($array);display array, variable indexes and array data
EndFunc;main()

func arrayout($array);use index variables to display array's data in SciTE
    for $i= 0 to $arraymax-1
        for $ii= 0 to $arraydatamax-1
            consolewrite("$array["&$i&"]["&$ii&"]= "&$array[$i][$ii]&@crlf)
        next;ii
    next;i
EndFunc;arrayout()

Edited by Xandy

I am not a lawyer.  (-_-) Xandy About  (^o^) Discord - Xandy Programmer

Share this post


Link to post
Share on other sites

For $iRow = 2 To $rows-1

;$arrdisp = $aArray[5]

MsgBox (0,"rows",_ArrayToString($aArray[$iRow]))

$TestOne.AddStepResult($DataXSL.GetParameter("Description",$iRow),$DataXSL.Path,1)

;SplashTextOn("XLS Data Provider - Row: " & $iRow,"Description: " & $DataXSL.GetParameter("Description",$iRow) & @CRLF & "Entry: " & @CRLF & $DataXSL.GetParameter("Entry",$iRow))

SplashTextOn("XLS Data Provider - Row: " & $iRow,"Description: " & $aArray[1][0]& @CRLF & "Entry: " & @CRLF & $DataXSL.GetParameter("Entry",$iRow))

Next

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0