array layout and getrows() 1

[chris5g]

I'm a little confused about the layout of an array returned by getrows().

It is my understanding that when you create a multidimensional array, myArray(10,3) the first number, 10, is the rows and the second, 3, is the columns.

However, when I pulled the data with getrows, this seems to be reversed. my variable numCols = UBound(myArray,1) + 1 is correct even though the columns should be the second dimension and not the first.

Is it reversed or am i just totally confused?

 

[cLFlaVA]

myArray( 10, 3 ) means create an array named myArray with 11 columns and 4 rows.

UBound( myArray, 2 ) means, give me the total number of rows.

http://www.codefixer.com/tutorials/multidimensional_arrays.asp

http://www.webcheatsheet.com/asp/multidimensional_arrays.php

*cLFlaVA
----------------------------
[tt]"quote goes here"[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[monksnake]

I'll try to explain this.

When you create the array myArray(10, 3), you specify rows then columns.

So when you put UBound(myArray, 1) + 1, we see how many of the first element in the array is (denoted by the , 1). The first "element" in the array is a 1 dimension array with a size of 11.

In this case, there happens to be 4 "elements" that contain 11 rows each. This is the same as saying how many columns there are.


<.

 

[cLFlaVA]

am i wrong?



*cLFlaVA
----------------------------
[tt]"quote goes here"[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[chris5g]

What I want to know is why do i use the first dimension of my array to get the number of columns when using the getrows() method instead of the the 2nd as in numCols = UBound(myArray,2) + 1?

Is the myArray(rows,cols) reversed when using the getrows() method as in myArray(cols,rows)

 

[monksnake]

am i wrong?

Not saying you are cLFlaVA. You just stated what it does and not how it does it.

I tried to explain why it happens the way it does. Apparently, I didn't do a good job.

cheers


<.

 

[cLFlaVA]

ah, ok. i was going to RF myself if i was.



*cLFlaVA
----------------------------
[tt]"quote goes here"[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[Tarwn]

There is no rule the says the first index of an array is the row and the second index is a column. This was common practice with array-like matrix variable sin some languages, but there is no hard and fast rule defined for naming array indexes. For example, I could use an array to define water temperature values in a cube of water using indexes longitude, latitude, and depth.

That said, yes, GetRows returns an array that is (column,row) so to get the row count you need to UBound(myArray,1) and to get the row count you need to UBound(myArray,2).

While I agree it would be more comfortable the other way around, after you get used to it you only get it backwards occasionally.

-T