I have an array that is two wide and an undefined length. The first
column is a name of a variable and the second column is the value of
that variable. How can i define all the items as there name = value?
i.e array(1,0) = X array(1,1) = 23 make it so that X = 23. This is
probably really simple and i would appreciate any help.
thanks
Perry

I don't think you can make X = 23 but you could create a function to which
you would pass your variable name & get the variable value back so that:
GetFromArray(X) = 23.
(The function would have to loop through the entire array looking for X, get
the corresponding value & exiting the loop once found)

This would allow you to access the array elements much like the elements of
a collection, which raises the question (in my mind at least) if you
wouldn't be better off simply putting your variables into a collection in
the first place. It may be a coin toss depending on what you are doing.

HTH


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an array that is two wide and an undefined length. The first
> column is a name of a variable and the second column is the value of
> that variable. How can i define all the items as there name = value?
> i.e array(1,0) = X array(1,1) = 23 make it so that X = 23. This is
> probably really simple and i would appreciate any help.
> thanks
> Perry
>

They are in two single arrays from a database recordset. I'm up for
any suggestions.

George Nicholson wrote:
> I don't think you can make X = 23 but you could create a function to which
> you would pass your variable name & get the variable value back so that:
> GetFromArray(X) = 23.
> (The function would have to loop through the entire array looking for X, get
> the corresponding value & exiting the loop once found)
>
> This would allow you to access the array elements much like the elements of
> a collection, which raises the question (in my mind at least) if you
> wouldn't be better off simply putting your variables into a collection in
> the first place. It may be a coin toss depending on what you are doing.
>
> HTH
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have an array that is two wide and an undefined length. The first
> > column is a name of a variable and the second column is the value of
> > that variable. How can i define all the items as there name = value?
> > i.e array(1,0) = X array(1,1) = 23 make it so that X = 23. This is
> > probably really simple and i would appreciate any help.
> > thanks
> > Perry
> >

Perry,
Not sure what you're trying to achieve, but from the subject, you cannot
change the name of a variable, only its value.
It seems that either you do not need a 2D array, or you are trying to use
arrays/variables incorrectly.

Explain what "X=23" is supposed to do/mean ?

NickHK

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have an array that is two wide and an undefined length. The first
> column is a name of a variable and the second column is the value of
> that variable. How can i define all the items as there name = value?
> i.e array(1,0) = X array(1,1) = 23 make it so that X = 23. This is
> probably really simple and i would appreciate any help.
> thanks
> Perry
>