array help

[cdkid]

ok, i'm just finishing up my _GetColNames() udf and what i need to do is

declare a variable then use it as an array...but i cant define it as an array because i dont know how many values are gonna be put into it so i get

Badly formatted variable or macro:

$ret[$i]= .Fields($i).Name

$ret^

--any help is much appriciated

~cdkid

[PsaltyDS]

ok, i'm just finishing up my _GetColNames() udf and what i need to do is

declare a variable then use it as an array...but i cant define it as an array because i dont know how many values are gonna be put into it so i get

--any help is much appriciated

~cdkid

Declare it with only one element, then use _ArrayAdd to add on however many are needed. Include Ubound() to keep element [0] = number of elements:

#include <Array.au3>

Dim $MyArray[1]

For $n = 0 to Random(0, 10, 1)
     _ArrayAdd($MyArray, $n * 2)
Next

$MyArray[0] = Ubound($MyArray) - 1

_ArrayDisplay($MyArray, "Table of numbers")

Hope that helps!

Edited January 29, 2006 by PsaltyDS

[cdkid]

thanks...i totally forgot about ReDim

--thanks again, psalty

~cdkid