>>>I have a method to look for tables saved buy certain users and create a SQL array.
>>>
>>>LOCAL ARRAY aHold(1)
>>>SELECT * ;
>>>FROM &tcTable ;
>>>INTO ARRAY aHold ;
>>>WHERE !lUploaded AND cUserName = cCurUser
>>>
>>>This works in the dev envir but not in the exe. Got any ideas?
>>>
>>>Thanks for the help
>>
>>Try dimensioning the array before the SQL Select statement. Size doesn't matter.
>
>...and you may start believing it if enough women tell you...
>
>It is important to dimension the array as a two-dimensional construct if you want to have local scoping - it's the two dimensional aspect rather than the size of the dimension. Trying:
>
>LOCAL aHold[1,1]
>
>might help. Of course, if the number of elements created by the query exceeds 65,000, VFP will give you the lovely 'Too many variables' error (# elements = #rows x #columns, but you knew that...)
>
>See, it's possible to be too big...

Geez, Ed. Is it your intent to bust my chops for me these days?< g > How about reading and commenting on my "Upgrade" thread, huh? Could really use your input there.

BTW, never had a problem with a select into a multi-column array dimensioned orginally with just the number of rows, but I'll take your word for it.